Article View: borland.public.cppbuilder.database.ado
Article #6029Re: SLOW insert speeds for access database
From: B Angus
Date: Wed, 22 Nov 2000 22:26
Date: Wed, 22 Nov 2000 22:26
22 lines
1418 bytes
1418 bytes
Just a guess. Try making sure marshall modified only is set. If you marshall all then the entire table gets sent and re-read on each updated row. "Vladimir" <darkice@mailbox.co.za> wrote in message news:3a1a6874_2@dnews... > 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:
<3a1c4974_1@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newspeer1.nac.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!216.232.79.183References:
<3a1a6874_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,b148961c50d456ee X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2000-11-22 14:33:11 PST From: "B Angus" <mdangus@psychtest.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3a1a6874_2@dnews> Subject: Re: SLOW insert speeds for access database Date: Wed, 22 Nov 2000 14:26:51 -0800 Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 216.232.79.183 Message-ID: <3a1c4974_1@dnews> X-Trace: 22 Nov 2000 14:32:20 -0800, 216.232.79.183 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newspeer1.nac.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!216.232.79.183