Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK or LOCATE?
Message
From
14/08/1999 16:09:58
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
13/08/1999 13:18:34
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00253099
Message ID:
00253784
Views:
41
All of this is speculation, but its just not that simple. Determining which index tag to use shouldn't account for that much delay. I only had one index in my little test program. The number of records is what caused the delay. Rushmore (in the LOCATE) is paving the way for a probable CONTINUE. Rushmore is paving the way for quick access of the records that meet the condition. This involves recording a list of records that met the condition and that would account for the delay increase with the number of records.

I should probably now refer you to Foxpro Advisor September 1996, and my own article in Foxpro Advisor July 1997. These articles operate on the premise that Rushmore is doing a lot more than a seek does.

Regardless, the point is that seek is way faster than locate in simple tests because the two search techniques are vastly different. There should not be any question which to use. Seek is for finding a single record, locate/continue and SQL are for finding a set of records.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform