Which is Faster?

[d4jaj1]

Hello,

For simple seaching of data (e.g., SELECT Statements), which is faster : TOracleDataSet or TOracleQuery? Is there really any performance difference between the two - assuming the same select statement is used?

Thanks

 

[Marco Kalter]

The TOracleQuery solution will always be faster. The TOracleDataSet uses a TOracleQuery internally, and needs to convert the SQL*Net data to TDataSet conventions, and needs to buffer records. The TOracleQuery does not need to convert or buffer anything, it is just a low-level encapsulation of an Oracle Cursor.

------------------
Marco Kalter
Allround Automations

 

[lev_ko]

Just how significant is the performance delta ? Did you measure ?

Thanks

 

[Marco Kalter]

If the server or network are the bottleneck, and the result set is not extremely large, then there will not be much difference. For local database connections the performance difference can be significant (something like 50%). For batch processing of extremely large result sets you should always use a TOracleQuery, assuming that you do not present such a result set to an end-user through data-aware controls.

------------------
Marco Kalter
Allround Automations