seek / locate / findfirst?

From: Lutz Kutscher (imnot_at_home.de)
Date: 08/25/04

Next message: Simon Bowyer: "Subquery and Yes/No field"
Previous message: Bill N: "Re: How to Handle a Timeout error"
Next in thread: Brian Bushay TeamB: "Re: seek / locate / findfirst?"
Reply: Brian Bushay TeamB: "Re: seek / locate / findfirst?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Wed, 25 Aug 2004 11:09:09 +0200

Hi,

I'm wondering, which of the named (Seek, Locate, Filter/FindFirst) is the
fastest way to search a TADODataSet for a specific record. The field value
I'm searching for is always a GUID-Value and the DataSet is loaded with
CursorType ctStatic, so all Searching is performed on the client.
I suppose, using the combination of Filter and FindFirst will be the
slowest, but how about the other two?

TIA

Lutz

Next message: Simon Bowyer: "Subquery and Yes/No field"
Previous message: Bill N: "Re: How to Handle a Timeout error"
Next in thread: Brian Bushay TeamB: "Re: seek / locate / findfirst?"
Reply: Brian Bushay TeamB: "Re: seek / locate / findfirst?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: Period of System.Random
... Get Lutz Roeder's .NET Reflector, ... Use it to decompile ... >I have been searching to try to find the period of the System.Random ...
(microsoft.public.dotnet.framework)
Re: seek / locate / findfirst?
... >CursorType ctStatic, so all Searching is performed on the client. ... Internally Locate uses Filter so its not going to be any faster than filter. ... FindFirst isn't supported by TadoDataset ...
(borland.public.delphi.database.ado)