This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am facing problem regarding pagination of the results. I am putting my problem more clearly to you.
I need to get the data from the database based on 6 values. The data which I get is very huge. This data needs to computed and I need to show the computed data to the user in seperate pages with each comprising 100 rows of data. The search criteria changes with every user.
In regard to my application configuration, I have a web server comprising UI, Action classes. These will communicate with the stateless session facade deployed in an App Server, and I can hit the database only through the App server.
Please provide me a solution so that I can hit the DB as less number of times as possible, and also that I need not store large chunks of data in the session (which is on the web server).
Thanks in advance.
P.S.: If I am wrong in posting this topic here, please move to the correct forum. [ July 24, 2005: Message edited by: Hemanth Pallavajula ]
Cheers,<br />Hemanth...<br />(When opportunity doesn't knock, build a door.)