• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in Printing Large Number Of Records in JasperReports

 
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.....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic