Link to home
Start Free TrialLog in
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

Avatar of Valeri
Valeri
Flag of Bulgaria image

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

MAybe look into CachedRowSet
ASKER CERTIFIED SOLUTION
Avatar of dojjol
dojjol
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dojjol

ASKER

did not get enuf help