>We have been using Filemon to disect what is happening when our program retrieves data from the database on the server. When one workstation is using the program it reads data from the server by reading the UNC of a mapped drive. For example if Y:\ is mapped to \\192.168.1.1\d$, instead of just reading Y:\, it reads \\192.168.1.1\d$.
>
>When two people are running the program it starts to read from the server by using the Y:\ instead of \\192.168.1.1\d$. These mutiple users experience a lot of latency that just one workstation running the program does not experience.
>
>We wonder if this has something to do with the latency they are experiencing because the program is having to translate what Y:\ is instead of initially reading the UNC like it does with one workstation.
>
>Has anyone ever heard of or seen this type of issue before with VFP? If so, how can I get VFP to read the UNC like it does with one user with multiple users?
Delays related to more than one user accessing the same database is sometimes attributed to antivirus software. You might disable it (temporary, of course, to test the assumption), or exclude specific files (*.DBF, *.FPT, *.CDX, for a start).
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)