Re: Oracle API for C/C++ ?

From: Rick Wessman <rwessman_at_us.oracle.com>
Date: 21 Oct 1999 08:29:14 -0400
Message-ID: <ug0z4523p.fsf@us.oracle.com>

A point of clarification: all accesses to the Oracle server go over SQL*Net/Net8. There is no other transport method.

                                        Rick

Jeffery Cann <jccann_at_home.com> writes:

> --------------867472A163F7DA7140D20B00
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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
>
>
>
> --------------867472A163F7DA7140D20B00
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Peter Sylvester wrote:
> <blockquote TYPE=CITE>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).</blockquote>
> 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.
> <pre>Jeff</pre>
>  </html>
>
> --------------867472A163F7DA7140D20B00--
>

                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.

Received on Thu Oct 21 1999 - 07:29:14 CDT