Hi,
I have an old VB6 application I am maintaining. We are migrating from Sybase 11 to Sybase 15. I am retrieving information from a stored procedure and populating several fields. The problem I am having is that when I run the stored procedure in Sybase 11, it runs and populates the fields in 4 seconds. However when I run the same stored procedure in Sybase 15 it takes 20 seconds.
I went into SQLAdvantage and executed the stored procedure in both Sybase 11 and 15 and it took only 2 seconds to retrieve the dataset in both versions of Sybase. I am using Sybase Client 12.51 and ODBC driver 5.00.0096.
When I go the ODBC connection and do a test connection, the Sybase 11 connection is instantaneous while the Sybase 15 connection takes 2 seconds.
I am at a loss as to why there is slowness in Sybase 15. Any help anyone can give me will be greatly appreciated.
Mark
I have an old VB6 application I am maintaining. We are migrating from Sybase 11 to Sybase 15. I am retrieving information from a stored procedure and populating several fields. The problem I am having is that when I run the stored procedure in Sybase 11, it runs and populates the fields in 4 seconds. However when I run the same stored procedure in Sybase 15 it takes 20 seconds.
I went into SQLAdvantage and executed the stored procedure in both Sybase 11 and 15 and it took only 2 seconds to retrieve the dataset in both versions of Sybase. I am using Sybase Client 12.51 and ODBC driver 5.00.0096.
When I go the ODBC connection and do a test connection, the Sybase 11 connection is instantaneous while the Sybase 15 connection takes 2 seconds.
I am at a loss as to why there is slowness in Sybase 15. Any help anyone can give me will be greatly appreciated.
Mark