Hello
What are difference between TOraQuery and TSmartQuery.
And how can I increase refresh speed in a big TOraTable.
Thanks
TOraQuery & TSmartQuery
In ODAC 6 the main difference between the TOraQuery and TSmartQuery componets is that the TSmartQuery component supports additional SmartRefresh feature.
In ODAC versions prior to ODAC 6, the difference is that the SQLInsert, SQLUpdate and SQLDelete properties must be set for TOraQuery component to make it modifiable. While the TSmartQuery component can automatically generate SQL commands to update underlying database table.
The Refresh method of TOraTable restores position of the current record after refreshing. This may cause the refresh operation to be long. If the current record is near the end of the dataset, all records up to the record that was the current one before refresh, are fetched during the refresh operation.
Try to use the Close and Open methods instead of the Refresh method. In this case only first 25 records will be fetched (if the FetchAll property is False and the FetchRows property is 25).
In ODAC versions prior to ODAC 6, the difference is that the SQLInsert, SQLUpdate and SQLDelete properties must be set for TOraQuery component to make it modifiable. While the TSmartQuery component can automatically generate SQL commands to update underlying database table.
The Refresh method of TOraTable restores position of the current record after refreshing. This may cause the refresh operation to be long. If the current record is near the end of the dataset, all records up to the record that was the current one before refresh, are fetched during the refresh operation.
Try to use the Close and Open methods instead of the Refresh method. In this case only first 25 records will be fetched (if the FetchAll property is False and the FetchRows property is 25).