Mike Yearwood
Toronto, Ontario, Canada
Walter Meester
HoogkarspelNetherlands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only