Devart Forums

I can see why QueryRecCount would execute a "select count(*)" SQL when fetchall is false, but why does it perform that SQL when fetchall is true? aren't all the records downloaded by the ODAC client before execution is handled back to the software? wouldn't it be much more efficient to count the records actually returned from Oracle to calculate RecordCount ?

Or am I missing something?

If you set FetchAll property to True then use RowsProcessed property of TORAQuery instead of
QueryRecCount.