Re: EAccessViolation whene executing long SQLCommand with TSQLQuery

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

Article #157

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

#157

From: Alper YAZGAN
Date: Wed, 18 Jul 2007 15:10

28 lines
2560 bytes

> I had a few curious questions for you:
> Do super size batches run quicker?

    It depends on what database you are using :-)
    I am currently and mostly using Sybase ASE and ASA, so they are fast 
when you want to run in batches like 1000 lines of inserts
> Are you using transactions?
   Yes, a batch does consist of a whole transaction.
> If so, do your rollback the entire batch if a single insert fails?
   Again yes, so actually I want this style of execution deliberately, but 
alternatively you can use (if you run insert statements) "if not exists then 
insert else update" style statements
> I have never used SQL statements so large myself...

   I developed a replication server, currently running on more than 350 
sites (Remote site dbs are ASA and the Central Server is ASE). My 
application replicates transaction continously - whenever the network is 
online - to the consolidated site - central server - so I need to batch the 
accumulated transactions from remote sites to the central server and it runs 
fast in batches.

My problem is that I could  run 1000 inserts in one batch using dbGo (ADO) 
but do not run using dbExpress drivers because of sql statement buffer  size 
limit.

Thank you again,

Alper YAZGAN

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<469cc35d@newsgroups.borland.com> <469cd7bf$1@newsgroups.borland.com> <469d401f@newsgroups.borland.com> <469d918f@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
From: "Alper YAZGAN" <alperyazgan@hotmail.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> <469d918f@newsgroups.borland.com>
Subject: Re: EAccessViolation whene executing long SQLCommand with TSQLQuery
Date: Wed, 18 Jul 2007 18:10:32 +0300
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-Antivirus: avast! (VPS 000757-3, 17.07.2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 212.174.62.11
Message-ID: <469e2d98@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1184771480 212.174.62.11 (18 Jul 2007 08:11:20 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 2422

Reply to Parent Message