Re: connecting to Oracle using C++ - best way?

anders43_at_gmail.com schrieb:
> thanks for the info about OCCI, will check that out. What about the ADO
> - how is the perfomance?

I've heard rumors that it's a bit slower than OLE DB because it uses XML at some stage or so.
But all this is irrelevant if you do a decent app. Here are a couple of pointers:

- Minimize roundtrips. Instead of thousands of queries/dmls, do one big one.
- use array binding for dml or PL/SQL parameters.
- Minimize the result set by doing as much as possible in the database. The

   only things done outside should be displaying it or processing it with    information that's not available in the database. - consider uploading that information into a temporary table and then

   process everything in the database, retrieving only a small result set.

If you do that, using OCCI, ADO or OLE DB will be so similar in performance that you can decide on the API purely based on which you are most productive with.

I'm quite fast enough using VBScript and OLE DB. I'd advocate OCI/OCCI only when you want to to a sql*loader type application and need the direct path loading API.

Lots of Greetings!
Volker Received on Thu Apr 20 2006 - 10:04:49 CDT