Re: EAccessViolation whene executing long SQLCommand with TSQLQuery

Article View: borland.public.cppbuilder.database.dbexpress

Article #156

Back to borland.public.cppbuilder.database.dbexpress Previous Next

#156

From: Dave
Date: Wed, 18 Jul 2007 04:08

13 lines
1575 bytes

> Yes, actually it seems to be ~64K.
> I could have run 1-1.2M batches with dbGo (TADOConnection, TADOQuery, 
> etc.).
> Now I will have to break down as you say.

Glad you got it to work.

I had a few curious questions for you:
Do super size batches run quicker?
Are you using transactions?
If so, do your rollback the entire batch if a single insert fails?

I have never used SQL statements so large myself...

Technical Details

Message-ID: <469d918f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <469cc35d@newsgroups.borland.com> <469cd7bf$1@newsgroups.borland.com> <469d401f@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: fb4e2,b20a52da5150773e
X-Google-Thread: f7a32,b20a52da5150773e
X-Google-Attributes: gidfb4e2,gidf7a32,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Dave" <DaytonaDave@dslextreme.com>
From: "Dave" <DaytonaDave@dslextreme.com>
Newsgroups: borland.public.cppbuilder.database.dbexpress,borland.public.delphi.database.dbexpress
References: <469cc35d@newsgroups.borland.com> <469cd7bf$1@newsgroups.borland.com> <469d401f@newsgroups.borland.com>
Subject: Re: EAccessViolation whene executing long SQLCommand with TSQLQuery
Date: Tue, 17 Jul 2007 21:08:21 -0700
Lines: 15
Organization: DaytonaDave@dslextreme.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 71.177.220.19
Message-ID: <469d918f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1184731535 71.177.220.19 (17 Jul 2007 21:05:35 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message