dbTalk Databases Forums  

Performance issues between SQL Native 10 and 9

microsoft.public.sqlserver.odbc microsoft.public.sqlserver.odbc


Discuss Performance issues between SQL Native 10 and 9 in the microsoft.public.sqlserver.odbc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bpdee
 
Posts: n/a

Default Performance issues between SQL Native 10 and 9 - 04-13-2010 , 12:45 PM






Hi,

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,
Dee

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.