Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Always better to ...?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00338054
Message ID:
00339091
Views:
28
>A blind LOCATE is the same as LOCATE FOR .T.. The Filter is optimized, as is >the deleted condition if the indexes exist.

So why if we are talking about optimization does a locate nooptimize run 250% faster than a locate on a 40K record table and a 100K record table? This is done on tables without filters.

Actually I ran the same test with a filter that did not match the index expression and the findings were about the same.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform