Avatar of dojjol
dojjolFlag for Afghanistan asked on

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

Java EEJava

Avatar of undefined
Last Comment
dojjol

8/22/2022 - Mon
Valeri

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...
jcott28

MAybe look into CachedRowSet
ASKER CERTIFIED SOLUTION
dojjol

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
dojjol

did not get enuf help
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes