maybe someone can point me towards a good design or some framework to help me meet the following requirements.

• Need to retrieve hundreds of thousands of objects from DB


• Dont want to retrieve them all at once


• use a page by page view


• display the total count also


• sort the result at any give displayed page