Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pro*C vs OCI

Re: Pro*C vs OCI

From: Sergei Kuchin <skuchin_at_sprynet.com>
Date: Thu, 08 Oct 1998 19:32:47 -0500
Message-ID: <361D59AF.1A17@sprynet.com>


From my experience, Pro*C is 5-12% slower than OCI. But that's not that big of a difference. OCI is more complex to learn and OCI programs are harder to write and support. In general, it boils down to how many people available on the market can do Pro*C and how many know OCI. I bet a hundred bucks the number is 20-30/1. On the bright side, there's some "wrappers" around OCI which make the use of OCI much easier. I, myself, has been thru the question "Pro*C vs. OCI" and the answer is "it depends." I ended up writing my own OCI "wrapper." Eventually, it became a piece of Freeware which is avaliable at:

        http://home.sprynet.com/sprynet/skuchin/otl_1pg.htm

Sergei

kdas_at_my-dejanews.com 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.
>
> 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
Received on Thu Oct 08 1998 - 19:32:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US