Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed of SEEK, SEEK(), LOCATE, and SQL SELECT
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00235086
Message ID:
00235187
Views:
25
>Interesting -- So I was correct after all recently about LOCATE being slower than SEEK, and I've noticed it since, also. I retract my retraction. < s > It seems to have some extra overhead that SEEK does not have. I've also seen vfp apparently confused on an optimized LOCATE on a large table (only the first LOCATE on a particular index), where it takes a few seconds to do anything at all occasionally, whereas I've never seen this with any SEEK...

This makes sense. When doing a LOCATE, VFP must search through all the tags to determine if one can be used for Rushmore optimization. If one isn't found, it is possible that VFP will build an index on the fly...again adding overhead (and significant in this case).
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform