libOracle performance issues

Hello,

I’m using libOracle (http://www-w2k.gsi.de/root/OracleAccess.htm) to connect from ROOT (3.10/02) to Oracle database server (Oracle9i Enterprise Edition Release 9.2.0.4.0).
I have noticed the great difference in the speed of query execution (uses indexes, returns about 5000 rows with one value) - query issued from sqlplus takes to execute several seconds, while executing it through libOracle takes much longer - even several minutes. Are there any tweaks possible?

Regards,

[quote=“mhulboj”]Hello,

I’m using libOracle (http://www-w2k.gsi.de/root/OracleAccess.htm) to connect from ROOT (3.10/02) to Oracle database server (Oracle9i Enterprise Edition Release 9.2.0.4.0).
I have noticed the great difference in the speed of query execution (uses indexes, returns about 5000 rows with one value) - query issued from sqlplus takes to execute several seconds, while executing it through libOracle takes much longer - even several minutes. Are there any tweaks possible?

Regards,[/quote]

Hello,
the libOracle interface was designed for flexibility (it uses dynamic SQL parsing), so it is not really high-performance tuned.

Nevertheless we tested it and got reasonable results, with a factor of 2-5 slower than SQL-plus.

Please be carefull to use the method showed in fetchdb.c demo macro to retrieve larger amount of rows. You should avoid parsing your query for each row, as this process takes the most time!

Michael