Board index » delphi » Which is quicker between a locate, the find methods or the goto methods

Nitesh

Delphi Developer
Mon, 20 May 2002 03:00:00 GMT

Which is quicker between a locate, the find methods or the goto methods

hi guys, I've heard many different opinions about the above search methods
and I  would like to know what some of you think, thanx in advance
nit...@kivtronics.co.za
 
Art Begu

Delphi Developer
Mon, 20 May 2002 03:00:00 GMT

Re:Which is quicker between a locate, the find methods or the goto methods


Findkey requires an index.  Locate doesn't but will
use it if there is one.  Locate will be slow without
an index.

Quote
"Nitesh" <nit...@kivtronics.co.za> wrote in message

news:825h5u$1pl16@forums.borland.com...
Quote
> hi guys, I've heard many different opinions about the above search methods
> and I  would like to know what some of you think, thanx in advance
> nit...@kivtronics.co.za

Art Begu

Delphi Developer
Mon, 20 May 2002 03:00:00 GMT

Re:Which is quicker between a locate, the find methods or the goto methods


An advantage of locate over findkey is
that findkey may not yield a true when searching on null
values for some field types but locate will
if you use asvariant.

Quote
"Nitesh" <nit...@kivtronics.co.za> wrote in message

news:825h5u$1pl16@forums.borland.com...
Quote
> hi guys, I've heard many different opinions about the above search methods
> and I  would like to know what some of you think, thanx in advance
> nit...@kivtronics.co.za

Team

Delphi Developer
Mon, 20 May 2002 03:00:00 GMT

Re:Which is quicker between a locate, the find methods or the goto methods


What database are you using. If you are using Paradox tables the Find and
Goto methods will be exactly the same. The Find methods are just wrappers
around GoTo. Locate will be slower, but probably not enough to worry about
unless for some reason it decides not to use the available index.

--
Bill

Bill Todd (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. Locate method - no current record / no record found

2. Static Methods vs Virtual Methods (with methods you expect to be overridden/redeclared)

3. locate method for FIND NEXT

4. TListView Find(Caption) method and highlighting the found item

5. Transaction Methods in Interbase using Delphi 3.0 -Problems in commit-rollback methods

6. Help: class method not calling correct descendent Create method

7. Class method pointers vs Object method pointers

8. Method 'Click' hides virtual method

9. Method Hide or Method OverRide?

10. Method Override or Method Hiding.