marcoDev Posted February 15, 2007 Share Posted February 15, 2007 hi, I'm a newbee with jasper report and ireport.I have a problem when i run a subreport inside master report. Each subreport take too many time, may be 200ms.For exemple :I have a master report with 8 subreport (one subreport = one sql query) and one subreport = 200ms All subreports inside a band detail, runtime 200*8=1600ms, it' enormous!I need help for optimization (SQL ok)Thinks. Link to comment Share on other sites More sharing options...
contentengineer Posted February 16, 2007 Share Posted February 16, 2007 Are you using Java or Groovy scriplet classes?--- Are the sub-queries all referencing a similar dataset, and could this be broken down to use a common temporary table across multiple sub-reports for better query performance - i.e. micro manage SQL performance? --- 1.6 seconds aint bad for report generation!! Link to comment Share on other sites More sharing options...
marcoDev Posted February 19, 2007 Author Share Posted February 19, 2007 hi,I did not use Java or Groovy scriplet.I have already think about temporary table, but I don't know if it's possible with jasper. --1.6s by element (sub-report) repeated 8 times by row for 8000 rows --> 1.6*8000 (extrapolation) thanks.Post edited by: marcoDev, at: 2007/02/19 11:51 Link to comment Share on other sites More sharing options...
marcoDev Posted March 16, 2007 Author Share Posted March 16, 2007 I solved my problem at using views in my database, it' s easier than add mutiple sub-report.The filling report is 10s + 10s for my sql report query Think. 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