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:
00235320
Views:
18
>
>I think Mike hit on the LOCATE delay -- it's not long enough to build an index on a large table (and where the index definitely exists), just a one or two second pause...

It could be that for a LOCATE, that if an index is not found that it just does a sequential search. I know that in a SQL SELECT, Rushmore will sometimes build an index and sometimes not...it tries to figure out if it needs one.
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