Database access to Oracle

[TheMillionDollarMan]

I realize that a lot of people maybe thinking that this is the wrong forum but wait.....

We use OCI now but our application is still slow. Do you think that using a different technology will speed it up?

Or should I say is OCI the fast C++ API with the most flexibilty and options?

I have read up on ADO, OLE-DB, OCCI ...OCI seeme the best for a lot of database work.

I could also use Oracle Stored Procedures etc But I think these a slower than my OCI - C++ application.

Thanks

 

[Cagliostro]

1. See what things are slow
1. startup of the application -- it is not a DB API problem
2. connection to DB is slow -- you may ignore this problem
because connections to DB are usualy not situated
in timecritical sections of applications
3. Execution of queries is slow -- Check if the same
queries runs fastly without C++, do it directly in
some Oracle frontend. If so, you should optimize
queries.
4. Execution of statements is fast but in C++ it is slow --
In this case, OCI statements are performed fastly. So
as result operation what you do in C++ are not
optimized.


Ion Filipski

 

[TheMillionDollarMan]

Thanks Ion.