• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Pagination jsp/java

 
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi 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 know 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.
 
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Check the article by Deepak Bala in the August edition of JavaRanch Journal.
Personally, I would display 50 records at a time and not get all the 100,000 records in one shot. Can't imagine what use it would be to the user unless he plans to download the result to analyze it further.

HTH
Shikhar
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic