Re: ADOTable is slow

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

Article #2505

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

#2505

From: Mike Ruskai
Date: Wed, 04 Jun 2003 10:07

13 lines
1492 bytes

On 4 Jun 2003 00:13:33 -0700, Thomas Vanting wrote:

>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!

Change the cursor type to clUseServer.  You're reading the entire table into
memory.

--
 - Mike

Remove 'spambegone.net' and reverse to send e-mail.

Technical Details

Message-ID: <gunaalqrneguyvaxarg.hfyc4r0.pminews@207.105.83.65>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3edd9c1d$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b301876c1fcb087e
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-06-04 03:09:22 PST
Newsgroups: borland.public.cppbuilder.database.ado
From: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net>
Message-ID: <gunaalqrneguyvaxarg.hfyc4r0.pminews@207.105.83.65>
References:  <3edd9c1d$1@newsgroups.borland.com>
Date: Wed, 04 Jun 2003 06:07:39 -0400 (EDT)
Reply-To: "Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net>
X-Newsreader: PMINews 2.00.1205 For OS/2
Organization: TLF
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Subject: Re: ADOTable is slow
NNTP-Posting-Host: 69.34.56.249
X-Trace: newsgroups.borland.com 1054721258 69.34.56.249 (4 Jun 2003 03:07:38 -0700)
Lines: 15
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message