Data inside the OracleDataset

[rinoshjoseph]

(DOA 3.4.5 and Oracle 8i)

I want to know how much data should be stored in Toracledataset. I had an sql "Select a.*,a.rowid from table_name"
and this table contains 80,000 records in Oracle. When I call dataset.open it takes 2-3 minutes to get data. Also if I made some changes and refresh it , it take almost the same time as .open. Is there any properties to get it in less time??

Is TDBChart Component compatible to TOracledataset. is there anything for DAO to replace this component.

 

[Marco Kalter]

You could set TOracleDataSet.QueryAllRecords to False. If you really want to process all 80,000 records, you should use a TOracleQuery instead though.

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