TOracleDataset as an in-memory dataset

[sergio.sette]

Hi,

in our application we often need a relative large amount of TOracleDataset components with the QueryAllRecords = True. We use these datasets only for lookups and we don't need to perform refresh/requery operation during the application session because the underlying oracle tables are static.
Because we use these datasets as in-memory tables (like a TClientDataset) and mantaining a large amount of unused open cursors can be a problem, is there a way to keep the dataset open and close the associated cursor ? Or should i use TClientDataset components instead ?

Regards

sergio sette

 

[Marco Kalter]

Currently the TOracleDataSet requires that the Session remains connected, and it also requires some open cursors for optimization purposes.

In the upcoming 4.0 release the TOracleDataSet can be instructed to close all cursors when no longer needed, and you can even disconnect the session and keep the result set.

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

 

[helmis]

In the upcoming 4.0 release the TOracleDataSet can be instructed to close all cursors when no longer needed, and you can even disconnect the session and keep the result set.

How to do that ?