>Hi all,
>We have a client running our VFP9 app in a network environment, on several Win7 workstations, with the following server:
>Windows Server 2008, Dell T310 server, Xeon 2.53 Ghz (8 core), 4GB RAM, Mirrored drives
>The app runs really slow in instances where information is queried from a lot of tables. Queries are optimized and are executing quite fast once started. The problem seems to be a latency in opening/accessing the tables. However, the same runs much faster when the app runs from a Win7 share (still across the network, same folder structure, same number of users connected) . Clearly, the problem is running when the data on the server.
>What we've tried so far:
>Disabled Write Cache on the server
>Disabled OpLocks and SMB2 on the server, as indicated here http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters EnableOplocks = 0
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters SMB2 = 0
>Neither of the changes above seem to make a difference one way or another, nor did it make a difference running the exe locally with just data on the server.
>Any comments on what may improve the performance on the server are appreciated. Thank you.


Sounds like the anti virus is checking the tables when they are first opened. For a test turn off the anti virus and try running to see if there is a difference. By the way, always turn off caching on a server no matter what the OS.