I am about to use LLBLGen paging features for the first time and I am wondering what would be the best way to use them...

In addition to selecting a subset (page) of data from the possible resultset, I am also interested in the count of the total resultset.

Should I run the same query twice, once for the data (with paging) and once for a count (without paging)?

Will SQLServer cache the query? Or is there a better more obvious way to do this?

Marcus

Just seen this thread which discusses the issues... http://llblgen.com/tinyforum/Messages.aspx?ThreadID=2579

Please ignore this thread.

Marcus wrote:

Please ignore this thread.

Must... resist....