Article View: borland.public.cppbuilder.database.ado
Article #4231Re: huge memory, slow - ADO for Access 2000
From: Vassiliev V.V.
Date: Wed, 27 Feb 2002 08:59
Date: Wed, 27 Feb 2002 08:59
34 lines
1831 bytes
1831 bytes
You may want to use server-side cursor, but you will lose some features available only on client-side cursor. Using indexes can improve performance too. Try also DisableControls() - EnableControls().. Regards, Vassiliev V.V. http://www.oledbdirect.com "Eckhard Richter" <eckhard@gmx.de> �������/�������� � �������� ���������: news:3c7bd6e8$1_1@dnews... > Hallo > > I've programmed a little application which uses ADO to store some data in a > ms-access-2000 table. > > Now my customer reported, that after some month everything works slow > > I see, it take now three minutes for ADOdata->Open() and takes all memory > accessable (some hundred megs) > (ADO String: Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=c:\Eckhard\fweblogs\log1.mdb) > MS-Access opens the same table (200.000 records) in seconds. > A BDE/ODBC-connection does it in 30 seconds. > > Whats wrong? > > Eckhard > > > > >
Technical Details
Message-ID:
<3c7ca460_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!sienna.impulse.net!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3c7bd6e8$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,852b42e175b41fd6 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-02-27 01:26:22 PST From: "Vassiliev V.V." <vv_vas@iname.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3c7bd6e8$1_1@dnews> Subject: Re: huge memory, slow - ADO for Access 2000 Date: Wed, 27 Feb 2002 11:59:07 +0300 Lines: 36 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.139.204 Message-ID: <3c7ca460_2@dnews> X-Trace: dnews 1014801504 62.118.139.204 (27 Feb 2002 01:18:24 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!sienna.impulse.net!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews