Yung Hung Yeung's client/server question made me think of a question that has bothered me since I first started using Foxpro.

In a client/server model, only the data that you specifically request is sent over the network back to the client, but I am unsure how VFP reads data from its built in tables (either from a local disk or a file server).

When you USE a table how much of the data of the table (if any) is loaded into memory? In VFP, data access is so blazingly fast that is is practically instantaneous for simple queries. The first time I installed a VFP app over a slow network connection, I noticed that queries and even simply skipping to a new record would take a bit of time.

Does this mean that VFP only holds the current record of current table in memory, or does it hold a subset of the entire table, or even the current record of every open table?