| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Pro*C vs OCI
A copy of this was sent to kdas_at_my-dejanews.com
(if that email address didn't require changing)
On Thu, 08 Oct 1998 21:11:50 GMT, you wrote:
>In article <35F5F13A.4FD5CB36_at_india.hp.com>,
> "K. Raghuraman" <kraghu_at_india.hp.com> wrote:
>> Hi Sebastien,
>>
>> OCI is a native interface with Oracle. Pro*C is the embedded code that
>> operate on an Oracle database. OCI is faster than Pro*C and does not
>> require any precompilers. OCI is pretty difficult to develop compared to
>> Pro*C. Also if you have any plan for migration to other databases, OCI
>
>I know this is a bit of a glib question, but can anyone describe how much
>faster OCI is when compared to Pro*C? As Raghu mentions, OCI is much more
>difficult to develop with than Pro*C. In my experience this has meant
>increased development timeframes for OCI vs. Pro*C. Also, as developers
>leave projects developed with OCI, maintainance issues arise as the number of
>programmers with a substantial knowledge of OCI isn't very high.
I didn't see the original post but...
Oci is *not* any faster then Pro*C.
OCI is an API layer on top of an API called UPI (upi is the internal, low level Oracle API).
Pro*C precompiles into an API called SQLLIB which is a layer on top of UPI as well.
Well code Pro*C is as fast as well coded OCI. A poorly written pro*c program might run slower then OCI and vice versa. As long as you take advantage of array fetching and reuse cursors as much as possible -- they offer comparable performance.
>
>Any help or observations would be appreciated.
>
>kdas
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 08 1998 - 16:49:15 CDT
 |
 |