<anders43_at_gmail.com> wrote in message
news:1145413812.532133.184160_at_e56g2000cwe.googlegroups.com...
> Hi,
>
> I was wondering what is the best (giving best performance) way to
> connect to an Oracle database?
>
> I have been using oo4o Oracle objects for Ole - does this give the
> fastest performance or is using ODBC for Oracle faster?
>
> TIA
> Anders.
>
Oracle Objects for Ole can be very fast.(Yes, in any api one can write bad
code.) If you use host or bind variables with it then it is very efficient.
Especially if you don't close cursors that you need again and again. Just
keep refreshing the query.
Jim
Received on Tue Apr 18 2006 - 21:58:30 CDT
