I have several little applications that I developed for my company and need to deploy them across a WAN to several remote locations. I am a little disappointed on the performance across the WAN. Even though the recordset fetches are relatively small (maximum 20 fields of no more than 30 records), the remote site metrics are very poor.

I use a combination of stored procedures and embedded SQL commands to get the data I need, and have seen very little difference in the performance either way. It almost seems as though the raw data is taking a long time to traverse the WAN.

FYI: we have 4 remote locations and each one is connected via no less than a 384K (up/down) dedicated pipe. We have monitored the bandwidth usage and it is nominal during the tests.

Is there a way to improve performance across a WAN? Compress/decompress the data? Hardware requirements on the remote machines?

If you need more info on anything, please contact me and I will provide whatever you need in order to help with a solution.