Re: ODBC vs Pro*c or OCI
From: David Sisk <davesisk_at_ipass.net>
Date: Tue, 20 Jul 1999 22:46:44 -0400
Message-ID: <nnal3.347$w3.414_at_news.ipass.net>
Date: Tue, 20 Jul 1999 22:46:44 -0400
Message-ID: <nnal3.347$w3.414_at_news.ipass.net>
Hi:
The OCI will definitely give you the absolute best performance and it's portable to any supported platform, but the API is a bit ugly. Pro*C is easier to code and is also portable to any supported platform, but doesn't provide as good performance, although it should still be quite good. ODBC will give you the highest amount of flexibility, the largest number of layers, the slowest performance, and the largest number's of potential problems.
If performance is what you're after, you can't go wrong with the OCI. That's what ERP systems like SAP use.
Regards,
-- David C. Sisk The Unofficial ORACLE on NT site http://www.ipass.net/~davesisk/oont.htm Furkan Khan wrote in message <37938010.85F41FD_at_home.com>...Received on Wed Jul 21 1999 - 04:46:44 CEST
>Folks, I am building a very high performance
>distributed application for the internet. I have a
>minimum requirement of at least 400 transaction/s (profiled on
>low end solaris box).
>
>What are the pros and cons of using ODBC vs pro*c or OCI ?
>I am interested in performance issues/experiences using
>ODBC. How is connection pooling in Oracle ODBC driver ?
>Are there any gotchas with ODBC for high performance
>solutions ?
>
>Can I use Oracle Advanced Queuing with Oracle ODBC ??
>
>Any ideas, suggestions appreciated. I can be mailed directly
>also.
>
>Thanks in advance.
>
>Regards.
>Furkan Khan
>