Re: Oracle API for C/C++ ?

From: Jeffery Cann <jccann_at_home.com>
Date: Thu, 21 Oct 1999 03:02:20 GMT
Message-ID: <380E8143.3B024388@home.com>

Peter Sylvester wrote:

> Shawn Lavin wrote:
> >
> > Several points to add :
> >
> > The Oracle precompiler actually converts Pro*C calls into OCI
> > calls.
> >
>
> Not so!
> Stange as it may seem, the Pro*C precompiler uses a different
> (undocumented) interface (sqlcxt, etc).

Pro*C is also much slower, especially over SQL*NET, than either OCI or OTL. This is because of the SQLCA structure that is supported by Pro*C. Each time you send a db command, this structure has to be filled with state information. Due to the fairly significant overhead of SQL*NET (sits on top of TCP/IP), we have found OTL to be 2-3x faster than Pro*C for the same database and code.

Jeff Received on Wed Oct 20 1999 - 22:02:20 CDT