🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1847

Re: Large tabels, overloading Last( ), Locate( ) in CDS

#1847
From: Josh Dahlby
Date: Tue, 26 Jan 1999 00:00
28 lines
1728 bytes
>Im thinking about overloading the last en locate procedures from CDS
>and using the RequestData procedure from TProvider.
>for example CDS->Provider->RequestData("Locate XXXX");
>The Provider Component on the server should handle this requests.
>so the result should be a data set with 10-> 20 records around the
requested
>record.  For the user it looks like he can scroll fast and the locate
takes
>some longer.
>
>Has anybody experience with this ?
>Or some other suggestions.


The only problem with this is you will need to make sure not to send
back duplicate records.  (Which may be difficult if you fetching batches
from different locations in the table.)  If you set FetchOnDemand to
False and then call Locate or Last it won't fetch all records. So for
example, if you want to do a Locate, but just want to see if it has
already been downloaded then you can set FetchOnDemand to False then
call Locate.  Then if it isn't found you could either fetch the record
from the server (like you mention above) or prompt the user that it may
take some time for it to find the record on the server.

Josh Dahlby
Delphi R&D

Please post MIDAS-related messages in inprise.public.midas
Technical Details
Message-ID: <78l2lj$g9@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <78cl4o$lg821@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,d5b02f3db412b0b7
X-Google-Attributes: gidfcd2b,public
From: "Josh Dahlby" <jdahlby@NOSPAMinprise.com>
Subject: Re: Large tabels, overloading Last( ), Locate( ) in CDS
Date: 1999/01/26
Message-ID: <78l2lj$g9@forums.borland.com>
X-Deja-AN: 437204772
References: <78cl4o$lg821@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Organization: Inprise Corporation
Newsgroups: borland.public.cppbuilder.database.multi-tier