Hi

We have some heavy task using table that are on a server on the basement. The network speed is 10 mb. These task is taking more than 12 hours. In these task we are extracting some data, scanning table.......

Foxpro table are flat file and someone told me that in this case this is doing lot of traffic on the network. In fact the processor of the computer doing these task is used about 2 to 14 % and the graphic about the network traffic is about 80 to 100%. The same person told me that using sql server for data will really make a big difference for the traffic on the network and the time for these task.

I wish the have the advice from people who move to sql server and if this is true.

Michel