>>Hi,
>>
>>I've noticed a slow down of a query when two users are accessing the same table on a network drive.
>>
>>If I start VFP, open the database, then run a query that pulls data from multiple tables, the query runs in about 2 seconds. If I then open one of the tables that the query accesses on another workstation in VFP, the query then takes 10 seconds. If I close the table on the other workstation, the query takes two seconds again.
>>
>>Any idea what could be causing this? It is happening on my network as well as a client's network where they have Windows Server 2003 running.
>
>Have you checked oplock setting ? Set SharingViolationDelay and SharingViolationTimeout to Zero on the server ?
Hi Thomas
Thanks for pointing that out. From what I'm reading (oddly enough from
http://support.microsoft.com/kb/889588) SharingViolationRetries set to 0 seems to imply there is no need for SharingViolationDelay and SharingViolationTimeout. Is that right? What side effects could there be for other files/users? Would they see more errors from the server - even if they are not sharing a file or would they just get a faster reponse from the server when attempting to access a file opened by someone else?
UPDATE: Why would this make a difference? If there is no violation, then there should be no second attempts or timeouts or delays, right?
Thanks