troubleshooting Question

ODBC performance over a WAN

Avatar of DanRollins
DanRollinsFlag for United States of America asked on
Microsoft SQL ServerC++
12 Comments1 Solution4029 ViewsLast Modified:
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.

My questions:  
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.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros