Taking long time to genrate a report in ireport

2

 

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 

 

Attachments: 
honeybakliwal's picture
Joined: Sep 8 2010 - 2:37am
Last seen: 8 months 1 week ago

3 Answers:

2

This might be the database related problem. Try running the query alone and see how much time query is taking,

ayushkumar.bilala's picture
Joined: Dec 3 2012 - 8:50pm
Last seen: 5 years 7 months ago
1

The data is fetched easily with not so much time

honeybakliwal's picture
Joined: Sep 8 2010 - 2:37am
Last seen: 8 months 1 week ago

How big is the result set of your query? How much is 'not so much time'?

marianol - 6 years 2 months ago

It takes only 23 seconds to fetch around 1 lac of records.

honeybakliwal - 6 years 2 months ago
0

Any luck on it

honeybakliwal's picture
Joined: Sep 8 2010 - 2:37am
Last seen: 8 months 1 week ago
Feedback
randomness