🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: OnFetchProgress and onFetchComplete

#3459
From: Mike Ruskai
Date: Fri, 30 Aug 2002 21:39
21 lines
2063 bytes
On Mon, 26 Aug 2002 07:20:16 -0500, albertfowler@earthlink.net wrote:

>What settings do I need to make these events fire? The documentation tells
>how to use them, but doesn't specify which settings to use and they are not
>being fired in my app. If this does not work how do I get the progress of
>opening a large access db?

They will only fire with client cursors.  That is, when you fetch the data to
a local memory buffer.  If you're fetching a lot of data, it'll be slow
because of the memory required to store it.  By contrast, using a server
cursor is pretty fast, since only those records which are "visible" by some
means will need to be in memory at any given time.  

So, you have to choose between slow and memory hungry, with fetch progress,
or relatively fast and lean, with no fetch progress.


--
 - Mike

Remove 'spambegone.net' and reverse to send e-mail.
Technical Details
Message-ID: <gunaalargpneevrepbz.h1oets0.pminews@207.105.83.65>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!news-in-sanjose!in.nntp.be!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <3d6a1cee@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,da5933b6f0e8bd0
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-30 15:02:38 PST
Newsgroups: borland.public.cppbuilder.database.ado
From: "Mike Ruskai" <spammoc.reirracten@begoneynnaht.net>
Message-ID: <gunaalargpneevrepbz.h1oets0.pminews@207.105.83.65>
References:  <3d6a1cee@newsgroups.borland.com>
Date: Fri, 30 Aug 2002 17:39:28 -0400 (EDT)
Reply-To: "Mike Ruskai" <spammoc.reirracten@begoneynnaht.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: OnFetchProgress and onFetchComplete
NNTP-Posting-Host: 207.207.231.177
X-Trace: newsgroups.borland.com 1030743542 207.207.231.177 (30 Aug 2002 14:39:02 -0700)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!news-in-sanjose!in.nntp.be!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail