Re: ODBC vs. OCI

chrise_at_shore.net (Chris Eastland) wrote:

>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.
>

Does the ODBC spec allow for non-blocking or async queries? I'm pretty sure OCI does.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!