> 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.

Well, I actually use SQL server in other projects, but I never felt that VFP can't compete with SQL server's speed in accessing database within small multi-user networks.


> SELECT * FROM table WHERE .t.
> is a bad SQL command if you don't need all the records from the table in the workstation.

I agree this is a bad SQL command, but it isn't the point of my problem. I only use it to measure the maximum time for creating the cursor. It is acceptable that it takes a couple of seconds if there is a large DBF with hundred thousands of records. But the real problem is that the second user (and all next users) increase this time to unreasonable duration and I wonder if there is workaround to avoid it.