OCI can be faster than pro C if written properly. Why one would use
multiple connections is beyond me. The problem with multiple connections is
that while it sounds cool and macho you now have a problem where one
connection may not see what another connection did.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Peter Vos" <peter.vos_at_dns.be> wrote in message
news:pan.2003.06.24.07.04.52.170758_at_dns.be...
> On Mon, 23 Jun 2003 13:58:36 +0000, Brian Peasland wrote:
>
> > OCI might be more than you need. Have you looked at using Pro*C instead?
> > You can write "cleaner" code without getting bogged down in all the OCI
> > details.
>
> I'm working on a piece of existing code, which uses OCI calls
> exclusively, but which has some problems. The decision to use
> OCI was made because of performance (is it really faster than
> Pro*C?)
> The type of documentation I am looking for, is to see why it
> makes OCI calls the way it does - which is in some ways a little
> different from the examples in Oracle's documentation: that does
> give an overview of OCI calls, and some examples, but I havent't
> found anything about why one would use multiple connections,
> contexts, ... and how it relates to efficiency.
>
> > Just a thought,
> > Brian
>
> Thanks,
> Peter.
>
>
>
> > [original message:]
> >
> > Peter Vos wrote:
> >>
> >> Hello,
> >>
> >> At the moment, I have the Programmer's guide from Oracle,
> >> which describes all that's inside OCI, but fails (at least
> >> for me) to explain how to use it efficiently.
> >> I have an application that stores a lot of queries, and
> >> executes them on demand. My questions are about when to
> >> prepare what statements, how to best use contexts and
> >> connections (and how not to use them - because there seem
> >> to be some bugs around),... and I would also like to know
> >> how to check what's really going on? (Maybe I prepare all
> >> statements, but don't get any extra performance - how do
> >> I check what Oracle does behind the scenes,...)
> >>
> >> Can anybody point me to a good book about OCI, or online
> >> documentation? Maybe even hints about using some of the
> >> existing C++ wrappers instead?
> >>
> >> Thanks,
> >> Peter.
>
Received on Tue Jun 24 2003 - 06:57:10 CDT
