Article View: borland.public.cppbuilder.database.ado
Article #4934Re: ADO slower than BDE!!?
From: Matt Jacobs
Date: Sun, 02 Sep 2001 01:43
Date: Sun, 02 Sep 2001 01:43
22 lines
1487 bytes
1487 bytes
Are you using the OLEDB provider for Jet of the OLEDB ODBC provider? You would have better luck with a prepared query. However, try setting the table's cursor location to clUseServer, cursor type to ctOpenForwardOnly (if you don't need to move back and forth - otherwise try ctStatic), lock type to ltReadOnly, and if you are opening a result set of more than just a few records, set the cache size to something like 20. This will give you a fast open. You don't need to modify the table, correct? Matt Jacobs -- My reply-to address is purposely mangled to thwart auto-reply bots. Please remove the two leading underscores if you wish to reply via e-mail.
Technical Details
Message-ID:
<3b918db1.2506525@forums.inprise.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3b910b75_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f5b85ddade8637c4 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-09-01 18:39:03 PST From: mattja@ix.netcom.com (Matt Jacobs) Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: ADO slower than BDE!!? Date: Sun, 02 Sep 2001 01:43:14 GMT Reply-To: __mattja@ix.netcom.com Message-ID: <3b918db1.2506525@forums.inprise.com> References: <3b910b75_1@dnews> X-Newsreader: Forte Free Agent 1.21/32.243 NNTP-Posting-Host: 24.9.166.132 X-Trace: dnews 999394678 24.9.166.132 (1 Sep 2001 18:37:58 -0700) Lines: 22 Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews