Hi Thomas,
>>What everybody was telling me ist to turn off opportunistic locking but that does not work. What happens then is that the first user encounters the same bad performance.
No, you don't get bad performance, you get normal performance.
Windows has a built-in optimization. If only one client is accessing a file, the client caches data locally. Reading and writing the file happens only on the client, not on the server. As soon as a second user opens the file, the client is notified and this optimization is turned off. Accessing the file now actually accesses the server. This optimization is called "opportunistic locking".
Hence, because the "slow" performance you see is the real performance, and the "normal" one actually an optimized one, you cannot make access faster with some configuration setting. You can do a lot to optimize the network in general like turning off virus scanners, making sure that network packets travel fast, changing MTU size, installing switches, etc.
On the VFP side you have to optimize your application to minimize network traffic. Pay close attention not only to the number of bytes you transfer, but also to the number of individual requests. Lots of requests slow down things, as well.
--
Christof