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.....
subject: Problem in Printing Large Number Of Records in JasperReports