Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Slow down when two users access data
Message
De
20/02/2008 13:09:08
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
19/02/2008 22:48:20
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:
01294356
Vues:
23
PMFJI - I added an entry for this topic to fox.wikis.com and gave you and Frank credit.

>Hi Frank
>
>>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.
>
>Yupp, similar to the story whetting my interest<g>. Highly doubtful if I would have scrolled that far down if you hadn't mentioned it<bg>.
>>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.
>
>So already more than 50% of the slowdown is gone - great start.
>
>>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.
>
>I would probably have done the same - check out if the idea has merit before getting down to measure the combinations. Looking forward to your results.
>
>>What does SMB stand for?
>
>Server Message Blocks - the acronym "Samba" was derived from. see:
>http://support.microsoft.com/?scid=kb%3Ben-us%3B935370&x=15&y=9
>describes anything relevant to your situation.
>
>regards
>
>thomas
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform