General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>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 ?
HTH
thomas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only