Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Always better to ...?
Message
From
29/02/2000 09:57:52
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00338054
Message ID:
00339079
Views:
32
>Bottom line, IMHO, don't rely on undocumented features.
..and sometimes you can't rely on the documented features either.

Re: Locate vs. GO TOP and "tricks"
I agree. According to design, use Locate when you can't use Seek because the criteria field isn't indexed. Also GO is for navigating to an absolute record number [or Top|Bottom] These concepts are very xBase to begin with. When you further limit the test by saying the table has to have a filter on it for locate to be faster, it's using an even more xbase mentality. (xbase is fine, but for extremely large tables, where it matters to measure 1.9s v. 1.1s, shouldn't SQL concepts be applied?)

Write solid code and if performance is a problem, take direction from Microsoft; simply require the client also make a hardware-upgrade investment. ("waddya mean i can't run Windows2000 on my 486/66, it's got 16M of RAM")
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform