aspose file tools*
The moose likes Other Java Products and Servers and the fly likes Problem in generating pdf Jasper  report from large amount of data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Problem in generating pdf Jasper  report from large amount of data" Watch "Problem in generating pdf Jasper  report from large amount of data" New topic
Author

Problem in generating pdf Jasper report from large amount of data

mike mimmis
Ranch Hand

Joined: Feb 11, 2011
Posts: 57

Hello Ranchers,

I am developing an web application using servlets and jsp using MySql as database. In my data base in one table there are 50000 records are there . I have to generate Pdf(or excel) from all those 50000 records. I am generating other reports which are nearly 2000 records These reports are executing perfectly. when I want to generate the report which contains all 50000 it is taking long time and after an half-an-hour also it is showing in browser as "generating report". I have used Virtualizer concept also.

While the same report is generating in "jasper report" software within 2-3 minutes. and also my query excuting with in one minute of time.

How to generate that report please give me any suggestions.....

please reply me....

Thanks in advance
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem in generating pdf Jasper report from large amount of data