• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Java pagination without pagination

Hello,
The application I am working on is quite old web application and currently we display number of records without pagination but now the records size is getting increased everyday and as per the client who uses this application does not want to change any view in the application i.e. we can not implement pagination but now when user runs the report, JVM runs out of heap size. Actually I have no where to go that is there any way without implementing pagination we can run the report with large data. Actually we run the report in HTML, Excel and CSV format.

Thanks,
dojjol

0
dojjol
Asked:
dojjol
  • 2
1 Solution
 
ValeriCommented:
make "pagination" during reading the data from the DB server.
instead of reading 50000 records at once and placing them on some map, read them 50 times per 1000 records, place these 1000 on the report, then read the other 1000 and so on...
0
 
jcott28Commented:
MAybe look into CachedRowSet
0
 
dojjolAuthor Commented:
Hey Valeri,
Could you pls provide sample or url link for the same.

Thanks,
Ankur
0
 
dojjolAuthor Commented:
did not get enuf help
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now