GetPaged selects all records for count

[jonvandermey]

[ModelName].GetPaged() produces two queries. The first selects all records just to iterate over them for a count, and the second to select the records according to the paging parameters.

With tens of thousands of records, it causes the fetching of 10 records to take a long time. I've narrowed it down to line 134 of the SubSonicRepository.cs file.
https://github.com/subsonic/SubSonic-3.0/blob/master/SubSonic.Core/Repository/SubSonicRepository.cs#L135

When the commented out code is used instead, the first query is a simple count query rather than than fetching every record.

[saintedlama]

Thank you for pointing out that issue, the implementation looks really weird - I'll fix that in the next days