Re: Pro*C or OCI, which is faster?

Hi,

OCI is more faster access method then Pro*C due to -

each Pro*C statement is expand typically at five OCI statements -

so if you remove "redundant" statements of OCI performance of your application based on OCI method will be more great then based on Pro*C.

Vladimir

In article <SxZtAAAVrxS3EwF9_at_rwx777.demon.co.uk>,   Steve Haynes <steve_at_nospamrwx777.demon.co.uk> wrote:
> In article <3748F7A8.A5532E69_at_mail.com>, Andrew Babb
<andrewb_at_mail.com>
> writes
> >James,
> >
> >I am not sure about the different versions of Pro*C, but OCI is
faster than
> >Pro*C. Not sure how much by, but this is something that Oracle states
due to
> >the fact that the call interface is at a lower level with OCI.
> >
> >Rgds
> >Andrew
> >
> I suspect the difference is not significant when compared to
> maintanance. oci 7 and 8 are way different, but pro*c is pro*c.
> I have only used oci when I needed arrays of cursors and
> pro*c didn't support it.
> Steve
> --
> Please remove nospam from my address to Reply.
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 27 1999 - 07:17:55 CDT