Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Slow down when two users access data
Message
De
19/02/2008 17:29:17
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
À
19/02/2008 15:22:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01293664
Message ID:
01294037
Vues:
24
SMB=Server Message Block, I would check it out, it does impact performance if not set correctly.

>>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?
Regards N Mc Donald
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform