Total number of rows that will be fetched

Lass.Mint · Post by **Lass.Mint** » Fri 11 Feb 2011 11:03

Hi,
I'm wondering if it is possible to find out the total number of rows that will be fetched by a uni-directional dataset without having to use "select count(1) from ..." or using FetchAll or something else that loads all rows. I want to do some optimizations in my code when there are less than ~100 rows that will be fetched.

Thanks for any help.

Eric

AlexP · Post by **AlexP** » Mon 14 Feb 2011 08:58

Hello,

To get the total record count you should set the QueryRecCount option to true.
In this case the following SQL statement 'SELECT COUNT(*) FROM ...' will be called automatically.

Lass.Mint · Post by **Lass.Mint** » Thu 17 Feb 2011 11:09

Thanks for the hint. It was a big help.

AlexP · Post by **AlexP** » Thu 17 Feb 2011 11:25

Hello,

It is good to see that this problem was solved. If any other questions come up, please contact us.