Re: ADO slower than BDE!!?

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

Article #4967

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

#4967

From: Matt Jacobs
Date: Sat, 08 Sep 2001 06:10

23 lines
1760 bytes

That's an interesting idea. Another option is to use a client-side
cursor, which may or may not result in the server allocating its own
forward-only cursor to fill the client cursor up until CacheSize is
reached and then fetch the rest as needed. You lose a little control
in this case as you don't know for sure what kind of cursor is
allocated on the server and you only get back enough records to fill
the cache.

Are you sure that all records are fetched? If this is true, that could
solve the problem of having multiple statements open with pending
results (if, that is, you set the connection "Multiple Connections"
property to false, which is a good idea if you are running out of
licenses).

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: <3b99b642.32921467@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!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3b910b75_1@dnews> <3b918db1.2506525@forums.inprise.com> <3b9460ac_1@dnews> <3b94fc28_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-07 23:07:33 PST
From: mattja@ix.netcom.com (Matt Jacobs)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: ADO slower than BDE!!?
Date: Sat, 08 Sep 2001 06:10:12 GMT
Reply-To: __mattja@ix.netcom.com
Message-ID: <3b99b642.32921467@forums.inprise.com>
References: <3b910b75_1@dnews> <3b918db1.2506525@forums.inprise.com> <3b9460ac_1@dnews> <3b94fc28_1@dnews>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 24.9.166.132
X-Trace: dnews 999929105 24.9.166.132 (7 Sep 2001 23:05:05 -0700)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message