>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!
Are other commands just as slow? If it is only the query, your query may simply not be optimized. See, for instance, my FAQ #8109, on Rushmore Optimization.
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)