Working on a project with a slow network connection (a sigle 10baseT line with around 20 to 40 users crossing it) to the server where a VFP database and tables reside. Users in the building where the data server is run data queries around 5 to 7 times faster than users across the street.
The application builds a temp VFP database on each client machine and populates it with local views of the VFP datbase on the server.
Here is my question. How much of a VFP table is actually buffered to memory when it is opened? My thought is since local views open the required VFP tables locally on each client machine and the processing to create the view is done on the client machine why do I see such a performance difference?