>when I first started VFP year ago, someone told me that in VFP, Locate is faster than Seek, since then I used locate all over my app. Now I'm planning to move my database from .dbf to MySQL, I wonder if the samething also apply to MySQL.
Hi Jerry,
You were lied to. In most cases SEEK is faster than LOCATE but it requres creating of compound indexes if you have to search for more than one field at the time.
However it's irrelevant to the client-server databases because they either don't support or are inefficient in the record based processing. For the cient-server backend you would use set oriented access - queries.
--sb--