Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Slow down when two users access data
Message
From
20/02/2008 13:09:08
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
19/02/2008 22:48:20
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:
01294356
Views:
24
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
Previous
Reply
Map
View

Click here to load this message in the networking platform