Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up search - Locate For or Seek?
Message
 
To
28/07/2000 09:23:40
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00397065
Message ID:
00398192
Views:
27
>Hi George
>
>I hope this continued discussion isn't fraying your nerves. When I run this code...
No it isn't.< g > As a matter of fact, your persistence led me to figure out what was wrong with my test.

First, I got the about same numbers as you did. Then I went to my table, and with some modifications to the original code. This time generating random record numbers to retrieve a variable to search on. Again, without the tag locate was faster. However, went I went back to a literal, with the tag was faster.

There was something else here that I didn't realize at the time. The table was in the process of being modified. One of the modification was that the index had been changed from the single field, to a location value plus the single field. Still, I'm at a loss to explain why, in one instance (with the literal) reversed the normal (expected) outcome.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform