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?
Amanda Morton
System Analyst
Harrisburg Project