I'm not really conversant with all of the details, but even though tables are buffered locally, there is a lot of buffer refreshing going on to avoid "dirty buffers" and data clashes. If there is a narrower pipeline for some clients than with others, there is going to be a speed issue regardless.
>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?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05