Are the fields on which the locate is done Indexed (at either the client or
server end)??
If you are using the briefcase model, is suspect it will have to load all
the records - an index may help.
You could perhaps do some advanced fudging of the IProvider interface -
depends on what data requests are sent from the client to the server.
Myles
> -----Original Message-----
> From: Carl Reynolds [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 08, 1999 1:03 PM
> 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/
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
