Sybase ODBC - Performace: ODBC vs. OpenClient

Author

Performace: ODBC vs. OpenClient

Roland

2005-08-03, 11:23 am

Hi Newsgroup,

does anybody know something gerenal about the performance of client
applications that use the OpenClient API or the ODBC API with Sybase
Adaptive Server?

Are there any general conclusions that e.g. ODBC is generally faster
than OpenClient?

Does anybody have results from performance tests of client applications
that use these APIs?

Thanks in advance!

Roland

Paul

2005-08-08, 1:23 pm

Hi Roland,

I do not think there is anything available like this. Comparing the 2 APIs
is rather difficult. In some cases I would think Open Client would be
faster, and maybe in others ODBC could be faster. I would think the
proprietary API (OpenClient) might be a bit better in performance overall,
but I have no solid evidence to this affect. To test the two APIs, someone
needs good knowledge of how the ODBC API will formulate its SQL that is
executed on ASE, and then use this same exact SQL form with Open Client,
then that would be the best test to run in comparison.

-PV

"Roland" <rolandrbox-01@yahoo.de> wrote in message
news:42f0ea81@forums
-1-dub...
>
> Hi Newsgroup,
>
> does anybody know something gerenal about the performance of client
> applications that use the OpenClient API or the ODBC API with Sybase
> Adaptive Server?
>
> Are there any general conclusions that e.g. ODBC is generally faster
> than OpenClient?
>
> Does anybody have results from performance tests of client applications
> that use these APIs?
>
> Thanks in advance!
>
> Roland

Ashish Mahajan

2005-08-09, 8:23 pm

Also to add to that if you are using ASA, you might be better off using ASA
ODBC driver as that uses a different and preferred network protocol than
open client for ASA...

For ASE the general rule of thumb is that if you want to tie your
application to ASE, use open client. If you want to be database agnostic,
use ODBC. Finally as ODBC and open client drivers against ASE use the same
network protocol, there should not be much difference in performance but if
your application makes ODBC calls that need Database metadata, then you will
end up causing the driver to do multiple round trips to the server thereby
slowing it down.

Bottom line, depends on the application.

HTH,

Ashish

"Paul" <Paul@sybase.com> wrote in message news:42f79078$1@foru
ms-1-dub...
> Hi Roland,
>
> I do not think there is anything available like this. Comparing the 2
APIs
> is rather difficult. In some cases I would think Open Client would be
> faster, and maybe in others ODBC could be faster. I would think the
> proprietary API (OpenClient) might be a bit better in performance overall,
> but I have no solid evidence to this affect. To test the two APIs,
someone
> needs good knowledge of how the ODBC API will formulate its SQL that is
> executed on ASE, and then use this same exact SQL form with Open Client,
> then that would be the best test to run in comparison.
>
> -PV
>
> "Roland" <rolandrbox-01@yahoo.de> wrote in message
> news:42f0ea81@forums
-1-dub...
>
>

Sponsored Links