Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is faster, locate or seek ?
Message
From
10/03/2000 10:23:38
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00344153
Message ID:
00344196
Views:
22
Mark,

Seek is faster than locate because it doesn't have the overhead of rushmore. The larger the table gets, the faster SEEK gets compared to locate.

Walter,

>If I have a table that has 5 fields that if combined create a "primary key", is it faster to use LOCATE to find a record, or SEEK.
>
>The 5 fields are not all characters fields (one is date and one is numeric).
>
>Regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform