>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.
Michael,
Because of the throughput difference between the local hard drive and the network, disk I/O is most likely going to be 10 or more times slower.
I suggest you optimize the code on your hard drive first. See if you can get it faster than it currently is. Create indexes, normalize tables, etc... After you have done, put it on the network. If the performance isn't satisfactory, try changing network hardware (e.g. faster network cards, hubs, switches, etc.).
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao