Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK or LOCATE?
Message
From
13/08/1999 01:21:03
Walter Meester
HoogkarspelNetherlands
 
 
To
12/08/1999 16:31:49
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00253099
Message ID:
00253316
Views:
33
Mike,

>Locate reads the entire index tag, seek hops through the tag by halves as it gets to the seek value. If your tables get larger, locate will get slower and slower while seek will stay relatively fast. That's why its recommended in tight loops.

Well, I doubt if this is true. I've got some clues that rushmore optimizable commands don't read the entire index tag when in the form of "FOR eExpresion".
One of my client has a WAN 64 kbs connection. When I open a large table with a large CDX file and isue a BROWSE FOR eExpression where a certain article index tag is used, It certainly does not read the entire tag, because the result is shown within a second (the entire tag might be something like 500k, the CDX about 3 or 4 MB)

That the LOCATE command is a bit slower than SEEK might have other causes, like the LOCATE Being a more complex command than seek, so it might take more time to process the command in terms of the internal C++ code.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform