>>I'm new to VFP.
>>
>>Could anyone tell me the diference between LOCATE FOR
>>and SEEK?
>
>From fastest to slowest:
>
>SEEK command (must have ORDER set)
>LOCATE with Rushmore
>LOCATE without Rushmore
>
>I'm not sure where the SEEK() function fits.
A couple cents...I would guess (from experience, mostly) that SEEK & SEEK() are about equally fast, though SEEK() might have a tiny fractional bit more overhead for the additional parameter evaluation, as well as locating table and setting order if not already set. Same is true for INDEXSEEK(). But then both of these functions are generally more flexible than SEEK...
Also, I've found that on large tables any SEEK is waaaaayyy faster than even a fully optimized LOCATE. For whatever reason, Rushmore is not very efficient with LOCATE...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.