After many benchmark tests and 18 years of FoxPro programming experience, I'll stick with SEEK() anydays.

>Hi Mike,
>
>SEEK() and LOCATE are equally fast because of Rushomore.
>
>>Index your table on flag and use SEEK().
>>
>>>hi all,
>>>
>>>i have table with more than 10,000 records, at network(many users).
>>>
>>>i need to found record with flag=0,to get all information at myform
>>>
>>>i useto locate to finde it as under,maybe somthing else faster.
>>>any idea
>>>

>>>USE newdnc
>>>LOCATE FOR flag=0
>>>if found()
>>>    thisform.text4.Value=char2
>>>    thisform.text7.Value=char3
>>>    thisform.text6.Value=char4
>>>    thisform.text8.Value=char5
>>>    thisform.text5.Value=char6
>>>else
>>>    =MESSAGEBOX("not found")
>>>endif
>>>

>>>thanks.
>>>m.qasem