Devart Forums

I am using TCientDataSet to cache some data on client. It is filled from TOraQuery using TDataSetProvider. What are best setings of TOraQuery in this case ?
I set readonly = true
FetchAll = true because i want all records to be cached TClientDataSet.
If i try set UniDirectional = true FetchAll was reset to false.

The best way is to set UniDirectional property to True. In that case TOraQuery component does not place fetched records in the internal buffer. So FetchAll and FetchRows properties are not used with UniDirectional. When UniDirectional is True, an application requires less memory and performance is improved.