>I've created an executable using VFP6.0 that does some calculations and creates tables in about 10 minutes on my local PC. When I move it to a server it takes WAY longer to run (well over an hour). Is there any way to speed it up when running from the server? The server is running WindowsNT4.0 and I need to run it from a LAN and WAN.
>
>Any suggestions would be greatly appreciated.
If searching for records / SQL queries are involved, perhaps my FAQ on Rushmore can give you some ideas for 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)