[Rails] Pagination Helper Thoughts

[Lon Baker]

While using the pagination helper and creating a search function I 
noticed that I had to perform 2 queries. The first query to get a count 
the number of records and a second query for the actual page of 
results.

My thought is would it be more efficient to simply grab the message 
with the first query and then in some way filter the results for the 
actual page? In WebObjects I could create a "qualifier" to apply to an 
array or use kvc to select a subset of the results.

Sorry if I may be pulling a noob move here since I am still shaking the 
java/wo mindset. I would love to here any thoughts on this.

--
Lon Baker