QueryRecCount

Alon · Post by **Alon** » Fri 23 Dec 2005 01:34

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?

Challenger · Post by **Challenger** » Fri 23 Dec 2005 09:59

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