I have a report which takes around half an hour to generate a report. Please suggest some solution, In the report I have 95 fields with 25 variables and one scriplet and no subreport. The report has one group also .
attaching the ireportpro.conf file details
default_options="-J-Xms256m -J-Xmx2048m -J-Dorg.netbeans.ProxyClassLoader.level=1000 -J-XX:MaxPermSize=512m"
Attaching the code of report also
Posted on January 27, 2013 at 10:17pm
This might be the database related problem. Try running the query alone and see how much time query is taking,
Posted on January 27, 2013 at 10:20pm
The data is fetched easily with not so much time
Posted on February 4, 2013 at 5:30am
Any luck on it
How big is the result set of your query? How much is 'not so much time'?
It takes only 23 seconds to fetch around 1 lac of records.