>I've got an application where the database resides on a shared network folder.
>
>When more than one user accesses the program the app slows down or continuously displays the 'running query' progress bar over and over again.
>
>All of the forms are running in private data sessions.
>
>I use 'select ... into cursor tmpxyz' statements to load combo boxes, etc. on some of the forms.
>
>With just one user accessing the program it runs okay although it runs much faster on the machine which has the database locally.
>
>Any suggestions?
>
>Thanks!
Of course local data will be faster than network data. A hard drive controller has much higher throughput than a network card. Comparing those is like like comparing apples and oranges. When one user accesses data on a server Windows is configured to give that user a type of exclusive access. Once a second user accesses, there is a slowdown for both. You need to disable write caching on the server and oplocks. This is best for a shared DBF.
http://support.microsoft.com/kb/129202The performance will be the same across one or more users and then you can start to look at other things.