This is where SHARED databases slow down in performance.

You should rethink of using a SQL Server in the backend and VFP in the frontend.
In this technique, you retrieve only the records you need.

SELECT * FROM table WHERE .t.

is a bad SQL command if you don't need all the records from the table in the workstation.