Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Always better to ...?
Message
From
28/02/2000 20:43:14
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00338054
Message ID:
00338810
Views:
22
>FWIW, I ran George's test and was amazed to find out go top was about 400% faster than a locate. But locate nooptimize increased performance by 250%. It was still slower than go top but within exceptable limits.

As I said before, when filters are involved, I find LOCATE about 60% faster than GO TOP. 116K records, GO TOP takes 1.9ish seconds and LOCATE takes about 1.1ish seconds when a filter is set. (Filter matches the key) When the filter does NOT match a key, I still find LOCATE about 8% faster than GO TOP. YMMV.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform