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_at_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! [Quoted]
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 Thu Oct 21 1999 - 05:02:20 CEST