too many time to run subreport

[marcoDev]

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.

[contentengineer]

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!!

[marcoDev]

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

[marcoDev]

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.