ODAC vs BDE Performance Results

[yousky]

Hi ODAC Team,

I'm testing your ODAC components to migrate our existing Delphi 2007 BDE application to ODAC components. (more than 2 millions of query in database every days).

So I have executed your Performance project to compare ODAC vs BDE.

During the Fetching process BDE is always 2x faster than ODAC.

Please find below several informations:

Oracle: 10g (Remote)
ODAC: 9.4.12 29-Sep-14
BDE: 5.01

i7 CPU
16Go RAM
Windows 7 64Bits

More over on several SELECT statements like "SELECT NULL FROM TABLE WHERE ...... AND .... AND ...."
that do not return any record, BDE only takes 0.5 milliseconds but ODAC takes more than 5 secondes to execute the query

Another topic about this fact is existing on your forum, I'm wondering if you have any advises for tuning ODAC ?

Many thanks

Regards
Greg

[AlexP]

Hello,

To increase performance on fetching, you can modify the OraSession.Options.OptimizerMode property, for example, by setting it to omFirstRows1000, and setting Fetch Block Size (OraQuery.FetchRows) to 1000. For moptimal performance, these properties' values should be selected experimentally. You can find an article about increasing performance in the documentation: http://www.devart.com/odac/docs/increas ... rmance.htm