pagination strategy - java/jsp/struts - very urgent
843840Aug 13 2008 — edited Aug 13 2008Hi all,
My requirement is to display around 1 lakh records to user in UserInterface(WEB APPLICATION - JAVA1.5/JSP/STRUTS/TOMCAT 4.1.29/ORACLE 9i). I hope pagination is the better way to implement this. I am supposed to display 50 records per page. Tell me what is the better way to handle this. Either to get all the 1lakh records in a single fetch from database and show sets of 50 records to user or fetch data from database whenever the user clicks pagination links to fetch the particular 50 records.
I hope fetching the entire set of (1 lakh) records in one go is better. But where will i store them? Is it possible to store in a cache if so How?
I heard something about CachedRowSetImpl in JDBC. Can i store all the one lakh records in CachedRowSetImpl object. Will it affect performance (memory). Will it be scalable if more users request the page. My important requirement is to display the first page with first 50 records as quick as possible to user (around 15 secs).
Could anyone please suggest me the best possible approach to go ahead with pagination with above requirements. Your help is highly appreciated. Thanks in advance.