ADOTable is slow

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

Article #2503

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

#2503

From: Thomas Vanting
Date: Wed, 04 Jun 2003 07:13

7 lines
1151 bytes

Hi,
can enyone tell me how speed up the Active property.
I have an MS Access database connected thorugh a ADOTable, the database is approx. 100MB. When I set the Active to true it takes 40 sek. before it's ready for use!

Thanks,
Thomas Vanting

Technical Details

Message-ID: <3edd9c1d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b301876c1fcb087e,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-06-04 00:21:20 PST
From: "Thomas Vanting" <thomas.vanting@velux.com>
Sender: "Thomas Vanting" <thomas.vanting@velux.com>
Reply-To: "Thomas Vanting" <thomas.vanting@velux.com>
Subject: ADOTable is slow
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 80.196.210.18 80.196.210.18    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3edd9c1d$1@newsgroups.borland.com>
Date: 4 Jun 2003 00:13:33 -0700
X-Trace: newsgroups.borland.com 1054710813 207.105.83.65 (4 Jun 2003 00:13:33 -0700)
Lines: 7
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail