Jasper performance in long reports

[2001 JI Open Discussion]

By: John Pollard - johnnypoll

Jasper performance in long reports

2002-11-06 09:18

I have an 80 page report, 8 columns and 75 rows per page which is taking 40 seconds to run including data queries. The majority of the time, 32 seconds is taken in filling the report.

 

This is bearable, but when I have a 200 page report, the query and calculations still only take around 10 secounds but the filling process then takes well over a minute.

 

I have put timings within my JRDataSource and shown that for the 80 page report, processing time in this class (methods next() and getFieldValue()) accounts for less than two seconds out of the 32 used up during filling.

 

Removing one column from the detail reduces the time by around 4 seconds.

 

Is there any hope for getting improved performance for long reports?

 

Thanks

John

 

 

By: Teodor Danciu - teodord

RE: Jasper performance in long reports

2002-11-06 13:24

 

Hi,

 

Performance was always one of my main

concerns.

 

I'm not sure there is something simple we can

do about it.

 

I promise I'll review this issue.

Any hints will be appreciated.

 

Thank you,

Teodor

 

 

 

By: John Pollard - johnnypoll

RE: Jasper performance in long reports

2002-11-08 04:22

I'm very encouraged by your reply. I don't have any hints. I thought the use of strings to identify the column in every call to getFieldValue() might slow things down. But when I calculated how little time is actually spent in this method during the filling process I realised it is not significant.

 

I would be interested to know where most of the time is going but I haven't ever played with profiling tools. Anyone else good at this sort of thing? I've heard JProbe is quite useful.

 

John

 

 

By: Ricardo Trindade - rjst

RE: Jasper performance in long reports

2002-11-08 04:24

I've used JProfiler and it's very nice and simple to use, with a view to show critical paths.