m.pasquini Posted April 20, 2018 Share Posted April 20, 2018 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 Link to comment Share on other sites More sharing options...
hozawa Posted April 22, 2018 Share Posted April 22, 2018 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. Link to comment Share on other sites More sharing options...
m.pasquini Posted April 24, 2018 Author Share Posted April 24, 2018 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now