Article View: borland.public.cppbuilder.database.ado
Article #4229huge memory, slow - ADO for Access 2000
From: Eckhard Richter
Date: Tue, 26 Feb 2002 18:40
Date: Tue, 26 Feb 2002 18:40
17 lines
1397 bytes
1397 bytes
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:
<3c7bd6e8$1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!62.24.128.9.MISMATCH!news-1.opaltelecom.net!newsfeed.wirehub.nl!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,852b42e175b41fd6,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-02-26 10:45:37 PST From: "Eckhard Richter" <eckhard@gmx.de> Newsgroups: borland.public.cppbuilder.database.ado Subject: huge memory, slow - ADO for Access 2000 Date: Tue, 26 Feb 2002 19:40:07 +0100 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 NNTP-Posting-Host: 145.254.62.116 Message-ID: <3c7bd6e8$1_1@dnews> X-Trace: dnews 1014748904 145.254.62.116 (26 Feb 2002 10:41:44 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!62.24.128.9.MISMATCH!news-1.opaltelecom.net!newsfeed.wirehub.nl!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews