Paul,

This is expected behaviour in an optimize network.

If one user is working on the database, it will cache information on the local workstation. As soon as the second user comes, the write chache has to be flushed. And as soon as the table is changed, the read cache is disabled. From then on accessing the data automatically means direct network traffic.

The following link is discussing the novell network, but the same holds true for Windows Networks.
http://www.novell.com/support/viewContent.do?externalId=7001112&sliceId=1


All you can do, is make sure you minimize network traffic by making smart use of indexes and only requesting the information you need.

Walter,




>Hello:
>
>Does anyone have any information on why a network would be slow when two or more users are running a Foxpro application at the same time? In other words, the first user starts the application which opens some tables and queries them—no slowness. Then when another user starts the application the user will experience slowness opening and querying.
>
>Is this a router problem or something that needs to be configured on the physical server?
>
>Thanks!
>
>--Paul