Performance problems with TOracleDataSet and cursor variables

[ThomyKay]

I'm executing the exact SQL statement from TOracleDataSet.SQL and from PL/SQL package function called from anonymous block in TOracleDataSet.SQL (using cursor variable).

What I encountered is that executing the anonymous block version takes almost the double time than the SQL version. What could cause that effect? Some different handling in TOracleDataSet class?

The data are then fetched through MIDAS.

 

[Marco Kalter]

I have no immediate explanation. You could use the Oracle Monitor or some other tuning tool to verify the resource usage of both variants.

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