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.....
Whose rules are you playing by? This tiny ad doesn't respect those rules: