Performance issues between SQL Native 10 and 9 - 04-13-2010 , 12:45 PM
We have a product that uses both Progress and SQL. We are using the ODBC
SQL Native 10 client, 2008 SQL. When we create a schema holder using the
Progress supplied tool the connection is so slow it is unusable. When we use
ODBC SQL Native 9 client, 2005 SQL it is super fast.
The problem is independent of architecture or OS. It shouldn't matter if we
use a networked schema holder or a single user connection. The SQL database
has been local and remote.
How can we troubleshoot what the performance issue?
Thanks in advance,