SLOW insert speeds for access database

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

Article #6024

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

#6024

From: Vladimir
Date: Tue, 21 Nov 2000 12:25

8 lines
1088 bytes

i'm using BCB5 with ADO to use a access database.
im using ADOQuery to select, insert, update, etc..
this is just extremely SLOW, taking about 1 second just
to insert a row. inserting over 100 rows is just not feasable

any solutions to speed up this connection?

thanks

Technical Details

Message-ID: <3a1a6874_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!news.belnet.be!news.tele.dk!194.213.69.151!news.algonet.se!algonet!neel.uni2.net!newssuck.uni2.dk!bornews.borland.com!dnews!196.33.40.88

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b148961c50d456ee,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2000-11-21 04:20:39 PST
From: "Vladimir" <darkice@mailbox.co.za>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: SLOW insert speeds for access database
Date: Tue, 21 Nov 2000 14:25:25 +0200
Lines: 19
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 196.33.40.88
Message-ID: <3a1a6874_2@dnews>
X-Trace: 21 Nov 2000 04:20:04 -0800, 196.33.40.88
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!news.belnet.be!news.tele.dk!194.213.69.151!news.algonet.se!algonet!neel.uni2.net!newssuck.uni2.dk!bornews.borland.com!dnews!196.33.40.88