I have two servers. On one server I have the sorurce codes for the VFP app and on the other server I have the live data.

If I mapped a drive to the server where my vfp app source codes are located, the EXEC runs faster, however if I do not mapped a drive to the server where the source codes are located, the exec runs slower.

I am using Window trusted authentication and yes I do create objects dynamically.

Thus, how can I solve this problem?