Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK or LOCATE?
Message
From
13/08/1999 09:28:23
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00253099
Message ID:
00253370
Views:
32
Bruce,

>One thing I've found is that for the first optimizable LOCATE issued, on a table with many (20 or 30) tags, there sometimes is a distinct pause while vfp has to find the correct one. Subsequent LOCATE or CONTINUE are about as fast as SEEK after that...same thing, of course, with SQL...

>But that alone can be a reason to use SEEK instead of LOCATE (and even SQL where applicable), since order is already applied.

You might be right. All rushmore optimizable commands have to search for the right index (or indices) to optimize whereas SEEK uses the right index rightaway.

walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform