Bob,

Have you ensured that WORK/TEMP/SORTWK files are directed to the workstations' local drives?

Do you have an index on DELETED() in you major tables? If you do AND you do not have much in he way of actual deleted records, this canbe a problem. You would be better off without the index if that is the case.

Does your processing call other EXEs that may be coming over the line?

What other differences are there in their setup compared to the prior? Have their network folks ensured that there are no (new) bottlenecks or other performance issues as a result of the move?

good luck



>One of my clients has moved the server with a VFP app to another building and installed a 512K fixed link back to the original site. Users at the original site are now experiencing major delays in accessing records (up to 3 minutes!) from an SQL query.
>
>The length of the delay suggests to me that the supposedly 512K fixed link is not transferring data at anything like that speed......or is a 512K link just too slow.
>
>Any ideas? If the link is too slow, can I modify the app so that it becomes a client-server one with all processing done on the server? Any documentation on this?
>
>Ideas/suggestions gratefiully received!