Slow report generation on JBoss deployments

0


I'm facing a performance problem with a few reports deployed on JBoss AS 7. The report generation become slow with time.
We noticed that very often, but not always the generation time gets back to normal after a JBoss restart.

The reports are made of nested sub-reports calling an Oracle DB (no XML). What I noticed debugging the SQL calls is that the queries are executed in just a few tenth of seconds but
 there is a bounch of seconds lost in between one SQL invocation and the subsequents SQL invocations.

After a JBoss restart, the SQL execution time remains the same and the SQL calls are made one after another with no delay in between the calls.

We are on Jasper 6.2.1 and we run jasper compiled files

m.pasquini's picture
Joined: Apr 19 2018 - 6:13am
Last seen: 1 year 4 months ago

2 Answers:

0

Try checking the memory. It may be that JasperReports Server is caching memory.

Another possibility is jdbc pooling. Check if jdbc connections are being released.

hozawa's picture
46957
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 months 1 week ago
0

Thanks for the useful hints.

I'm checking the JDBC connections and they seem to be released.

We're not using Jasper Server: reports (jasper files) are deployed on JBoss and opened programmatically. 

Other ideas?

m.pasquini's picture
Joined: Apr 19 2018 - 6:13am
Last seen: 1 year 4 months ago
Feedback
randomness