Taking long time to genrate a report in ireport
Posted on January 27, 2013 at 10:05pm
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
Joined: Sep 8 2010 - 2:37am
Last seen: 4 years 9 months ago
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,
Joined: Dec 3 2012 - 8:50pm
Last seen: 9 years 8 months ago
Posted on January 27, 2013 at 10:20pm
The data is fetched easily with not so much time
Joined: Sep 8 2010 - 2:37am
Last seen: 4 years 9 months ago
Posted on February 4, 2013 at 5:30am
Joined: Sep 8 2010 - 2:37am
Last seen: 4 years 9 months ago
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.