>Fred, Mike and Terry,
>
>Thanks for your answers.
>
>Using your suggestion, I used SET FILTER, and got these results :
>
>GO TOP : 36 Seconds
>LOCATE : 23 Seconds
>
>Is this the expected difference ?
>
>Regards
>
>Cesar
That depends. Filtering in general can be slow. But I've never noticed any times anything like that. If your filter condition matches an index tag, the times for the LOCATE should be the same as a SEEK would produce, almost instant (though it's usually slower).
Say you had a tag named lastname on a lastname field. If you SET FILTER TO lastname="Smith" and then did a GO TOP, it might take a fair bit of time, while the LOCATE should be nearly instant. It may also depend on how many deleted records you have and if SET DELETED is ON or OFF.
If you need to get to the last record that matches a filter, you can SET ORDER TO TAG lastname DESCENDING, and then do the LOCATE. This would be much faster than a GO TOP or a GO BOTTOM.