Paging implimentation using Hibernate with Struts2

I am working on developing a paging solution using Hibernate as persistance layer and Struts2 as UI. I was following the thread Similar Thread at SO

and it seems that the answers are themself good and explanatory,i still have some query,since i can have maximum of 2-3000 records (assuming 1-2K) so its still good approach to fetch all sorted records from db and place them in a cache and impliment paging functionality on the cache records or should be something like fetch few hundered records only. we want paging functionality what SO have so i have already my logic 开发者_JAVA百科to impliment this,only concern is should i fetch records from DB per page request or go for some other approach.

as a note this paging functionalty is for backend management.

Thanks in advance

Fetch X records per page. Don't pull more than you need. Bozho's answer in that thread is best.

Are you having trouble implementing this?