Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Stary
  Where is Stary?
 Ljubljana
 Slovenia
 Stary
 To: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 Tags
Subject: RE: Slow access to DBF on network
Thread ID: 203810 Message ID: 203857 # Views: 45 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, November 16, 2008 8:35:24 PM         
   


>
> No shared files such as databases should be using opportunistic locking.
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q129202
>
> Make a point of testing with at least two workstations as the norm.


What exactly did you mean with this point?

I suppose the registry value of "EnableOplocks"
on the server's
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet
\Services\LanmanServer\Parameters


should be set to 0.

I tried to do that (with 0 and 1), but no difference in performances.
Actually, it is even worse with setting to 0. By default there was no registry key and I added it. If it was set to 1, performances were same as there was no key, but setting to 0 the access was slow even with first user.

It is interesting - when I connect to the server directly with 2 remote desktops at the same time, it isn't problem as it is with 2 users from real network workstations. So there must be something that could improve this multi-user access.



COMPLETE THREAD
Slow access to DBF on network Posted by Stary @ 11/16/2008 5:17:31 AM
RE: Slow access to DBF on network Posted by Tom Saddul @ 11/16/2008 2:07:09 PM
RE: Slow access to DBF on network Posted by Stary @ 11/16/2008 9:03:19 PM
RE: Slow access to DBF on network Posted by Mike Yearwood @ 11/16/2008 2:32:26 PM
RE: Slow access to DBF on network Posted by Stary @ 11/16/2008 8:35:24 PM
RE: Slow access to DBF on network Posted by Mike Yearwood @ 11/17/2008 3:20:12 PM
RE: Slow access to DBF on network Posted by Stary @ 11/17/2008 9:05:38 PM