Re: Fastest Way to Insert a Number of Records via SQL

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

Article #192

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

#192

From: Dan
Date: Tue, 05 Jun 2007 15:27

14 lines
1649 bytes

Vassiliev V. V. wrote:
> For Access (but not for most other DBMS) try to use TADOTable with
> CursorLocation = crServer. 

I did this and then did a quick test off inserting 100 sets of 520 
records, and the time was exactly the same.

Using transaction (open transaction, insert 5000
> or 19000 rows, then commit transaction, then start new transation etc.) will
> also speed up inserts (again, for other DBMS this may or may be not true).
> For best results you may look at third-party components, but they may
> require more code.

How can you batch transactions in this manner?

Technical Details

Message-ID: <466580d1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46645ac3@newsgroups.borland.com> <466477c6$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,d0a6c05550b4cac9
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 05 Jun 2007 10:27:15 -0500
From: Dan <Dan@do.not.spam>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Fastest Way to Insert a Number of Records via SQL
References: <46645ac3@newsgroups.borland.com> <466477c6$1@newsgroups.borland.com>
In-Reply-To: <466477c6$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 67.153.244.210
Message-ID: <466580d1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181057233 67.153.244.210 (5 Jun 2007 08:27:13 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message