Hi there,
I have asked the similar question before, unfortuantely none answered
it.
In my project, when I do a Locate, I pass the Locate( a record number or
a range string) params to the middleware, the middle checks the params
and prepares a subset of the dataset( normally 1 ~ 100 records) for the
client application.
When I started my n-tier prototype, I used the same method as yours.
Navigation is very slow.
Cheers
Yanbo
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Carl Reynolds
Sent: Wednesday, 8 September 1999 1:03
To: Multiple recipients of list delphi
Subject: [DUG]: Efficient searching in
TClientDataSet
When I do a Locate on a TClientDataSet, it immediately
loads all remaining records into its buffer, ignoring PacketRecords.
The same thing happens when using FindKey or GotoKey. If I don't want
to have all the records loaded automatically (because I have a very
large result set), is there a more efficient way to locate a record than
to step through one record at a time, checking each for a match?
Cheers,
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
application/ms-tnef
