Article View: borland.public.cppbuilder.database.ado
Article #4706Re: ADO Performance problems
From: Giuliano
Date: Sat, 17 Nov 2001 03:19
Date: Sat, 17 Nov 2001 03:19
24 lines
1582 bytes
1582 bytes
On Fri, 16 Nov 2001 13:40:52 -0700, "Ron" <noemailyouspammers@spamfree.com>
wrote:
>Hi,
>
>I have a large BCB5 database application that I have just ported over to ADO
>from BDE. For Query's that return small numbers of records it works just
>fine, but when a query retrieves over 10,000 records the performance goes
>down badly. I have ported my app to work on Access97, Access2002, and MS
>SQL Server with the exact same behaviour, so I think that all the blame lies
>in ADO and ADOExpress.
[snip]
Hi Ron,
try to set the CursorLocation property to clUseServer. If you would like
to read the recordset only in forward fashion, set the CursorType property to
ctOpenForwardOnly too.
Hope this helps.
Ciao!
Giuliano
Technical Details
Message-ID:
<3bf5d57f.325120468@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsReferences:
<3bf579f2$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,9defb43ff18ceee2 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-11-16 19:31:48 PST From: gcardinali@remove.adhoc.net (Giuliano) Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: ADO Performance problems Date: Sat, 17 Nov 2001 03:19:38 GMT Message-ID: <3bf5d57f.325120468@newsgroups.borland.com> References: <3bf579f2$1_1@dnews> X-Newsreader: Forte Agent 1.5/32.451 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 194.183.68.230 X-Trace: dnews 1005967559 194.183.68.230 (16 Nov 2001 19:25:59 -0800) Lines: 24 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews