Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Slow down when two users access data
Message
From
19/02/2008 15:22:40
 
 
To
19/02/2008 10:28:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01293664
Message ID:
01293950
Views:
23
>Hi Frank,
>
>>>Have you checked oplock setting ? Set SharingViolationDelay and SharingViolationTimeout to Zero on the server ?
>>
>>is the oplock setting you refer to the same as the SharingViolationRetries, SharingViolationDelay registry setting you refer to? Elsewhere I found that setting SharingViolationRetries to zero should help, so I am in the process of tryiing it out. I did not fimd anything on SharingViolationTimeout, did you mean Retries?
>
>Yupp... memory is the first thing to go if too often exposed to google. You should find under SharingViolation and performance a few KB and other posts, sometimes about .mdb (access) file sharing.
>OpLock is a caching behaviour useful for office documents but deemed hazardous for fileserver based data access. This "speeds up" the first user, but has to "unload" for the second user, thus adding to the speed difference. I gathered it to be safer to run fileserver data access always with oplocking turned off at lower speed, as there were reports of "malfunctions" running with oplocks on.
>
>The settings for SharingViolation make things worse if I understood correctly, but you should watch SMB traffic if setting only delay to zero.
>
>While we are at the topic: you might also check on the SMB protocol settings, there is a setting for SMB signing in Vista and some Server2003 versions nearly crippling performance.
>
>I'ld appreciate, if you could post your findings with measurements <g>.
>
>HTH
>
>thomas


Thomas,

thanks for pointing that out to me as it seems to have done the trick. I found this solution: http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/NT/Q_10088433.html
You have to scroll down to the end of the page to get the actual details.

Basically, what I have done is created the SharingViolationRetries in HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters to REG_DWORD 0 and this has knocked off approximately 5 to 7 seconds from the query times.

I did not create the SharingViolationDelay string.

Unfortunately I haven't done any accurate timing but once things settle down I'll try and do some and report back here.

What does SMB stand for?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform