So, Oracle abandoned TWO-TASK connections?
Rick Wessman wrote:
>
> 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:
> > <br>>
> > <br>> Several points to add :
> > <br>>
> > <br>> The Oracle precompiler actually converts Pro*C calls into OCI
> > <br>> calls.
> > <br>>
> > <p>Not so!
> > <br>Stange as it may seem, the Pro*C precompiler uses a different
> > <br>(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 - 17:25:47 CDT
