Poor performance on WAN links
145643Mar 4 2009 — edited Mar 23 2009Hi all.
I am working in to client/server real world applications, App1 is based on SQLServer and the App2 on Oracle (10gR2Linux x86 - RHEL).
I need to show that the applications work fine outside the LAN context, meaning that the applications can work on WAN links.
Both applications uses similar methods for data acess (ODBC - Bulk selects when possible, or cursor fetch). App1 is working fine when we move the client link to a WAN one, but App2 experience a huge drop of performance.
I do know that the underlying communication protocol (SQL*NET vs DBLib) has distinct implementations, and that the number of control packets of SQL*Net is much higher than DBLib.
Is there a way to configure SQL*NET or ODBC in order to minimize the number of Round Trips or Control Packets?
What else should I investigate?
Thanks in advance!