Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in generating pdf Jasper report from large amount of data

 
mike mimmis
Ranch Hand
Posts: 57
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic