Multiple INSERT INTO statements

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

Article #2743

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

#2743

From: Jonny
Date: Thu, 27 Mar 2003 19:16

13 lines
1328 bytes

Hi

I've got an application that needs to insert serval values into a table say
between 100-1000 rows.  At the moment i've got an ADO connection to the
database, and then using an ADO Query i've got an INSERT INTO statement
that's placed in a for loop adding each row.

This, however, is REALLY slow!  What's the best way do this quickly

Thanks


Jonny

Technical Details

Message-ID: <b5vimu$ruo$1$8302bc10@news.demon.co.uk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!diablo.theplanet.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4d999a3943779361,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-27 11:17:00 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!diablo.theplanet.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail
From: "Jonny" <jonny@nospam.jonnywilk.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Multiple INSERT INTO statements
Date: Thu, 27 Mar 2003 19:16:45 -0000
Lines: 15
Message-ID: <b5vimu$ruo$1$8302bc10@news.demon.co.uk>
NNTP-Posting-Host: alanwilk.demon.co.uk
X-Trace: news.demon.co.uk 1048792606 28632 80.177.110.156 (27 Mar 2003 19:16:46 GMT)
X-Complaints-To: abuse@demon.net
NNTP-Posting-Date: Thu, 27 Mar 2003 19:16:46 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Priority: 3
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MSMail-Priority: Normal