Re: ODBC vs. OCI

From: Chris Eastland <chrise_at_shore.net>
Date: 1996/07/10
Message-ID: <4s0p10$6nt_at_northshore.shore.net>#1/1

kmajkut_at_netcom.com (Keith Majkut) writes:

>In article <31E100D0.57B1_at_bearriver.com>, <mquan_at_bearriver.com> wrote:
>>Hi. Does anyone have performance statistics for difference between
>>ODBC (Visigenic driver) and OCI? This is for the Mac 68K and/or PPC
>>platforms. Thanks.
>While I don't have any numbers, remember that the ODBC driver will be
>written on top of OCI (Oracle Call Interface). This would suggest
>that a well written OCI app will always be faster that a comparable
>ODBC app.
>>- mquan_at_bearriver.com

You might want to make sure the Visigenics driver uses array fetching rather than asking Oracle for a row at a time even though you're using SQLExtendedFetch , if you want speed for retrieval.

Apart from that, OCI is far more straightforward, in my opinion, than the ODBC spec. Received on Wed Jul 10 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Chris Anderson: "US-CA-Sacramento Technical Support Engineer, Unify Corporation"
Maybe in reply to: mquan_at_bearriver.com: "ODBC vs. OCI"
In reply to Keith Majkut: "Re: ODBC vs. OCI"
Next in thread: Dennis Cochran: "Re: CREATE/TRUNCATE in PL/SQL???"
Reply: Chuck Hamilton: "Re: ODBC vs. OCI"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message