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.