>>SEEK works on an already open table with an existing index set. So, many of the records are buffered already, and perhaps the index is too. The closest comparison you might be able to get to was from a fresh reboot compare...
>
>>USE Table
>>SET INDEX TO
>>SEEK
>
>Well this is not fare either. If comparing the SQL - Server solution with the VFP solution, the SQL-server database is already open and probably a fair amount of the database is buffered also, esspecially when doing such tests repeatedly.

This is why I said '...from a fresh reboot...'

BOb