>Hi there! I am a reletively new FoxPro user and I had a question concerning searching a table. I am currently using Locate for's to search for my results, but I have been told that seek is quite faster. Is there something faster than seek? And can anyone explain in a nutshell what makes one faster than the other? Also, I already have a ton of indexes on the table too. Thanks for any answers you all can give me! :)
Seek will give the fastest possible performance for positioning in a table assuming that a tag exists, but only works if a tag corresponding to the field or a concatenation of the field with other fields exists; LOCATE works regardless of the existance of index tags.