My application is retrieving data from SQL Server 2000 over a WAN using ODBC (VFP 9). Users are complaining about the performance and the networking people at the customer are pointing to my application, saying that it is communicating with very small packets - like 250 bytes or so. Thus it takes over 10 separate packets to return one row of data (2568 bytes).

I thought the default was something like 4KB packets?

I'm not knowingly doing anything to set the packet size - is there something I can do (or should do) to improve this?

Or is there some other quirk in what I have done that causes this?

Thanks,
Pat