Jump to content
Changes to the Jaspersoft community edition download ×

too many time to run subreport


marcoDev

Recommended Posts

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

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

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

  • 4 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...