TOracleQuery v's TOracleDataset

[iansmith]

Are there any performance gains using the Toracledataset instead of the ToracleQuery?
If so what are they and how can they be implemented.

 

[Marco Kalter]

A TOracleDataSet is only useful if you need TDataSet compatibility (e.g. for data-aware controls), or if you need to navigate back and forth in the result set.

The TOracleQuery is a low level encapsulation of an Oracle cursor, and does not allow any other navigation than "Next". Because of its low level nature, it will always be faster than a TOracleDataSet.

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