I have an application that uses MFC CDatabase and CRecordset objects (and thus ODBC) to access a SQL Server database. The performance is fine when the database is local or nearby on the LAN.
When running over a WAN, using the ODBC Administrator to set an IP address as the SQL Server, the performance takes a nasty hit. For instance, a process that's normally done in about 1 second blows up to an unacceptable 30 seconds.
Most of the work is forward-only, read-only access. It's reading sets of records and generating formatted text into a local memory buffer.
1) Is this type of ODBC access known to be vastly slower than say, ADO access when used on a WAN?
2) Are there any settings or options that might improve the performance? It would need to be a considerable improvement... e.g., a 10% boost won't help at all.