Jasper Performance Parameter

[prashantckc]

Hi All
I am trying to generate the PDF file with 10Laks record and its taking huge amount of time.

Can you please help in how can we improve the performance?
Are there any guidelines in Jasper for performance setting?

[darth_fader]

There are a few things you can do to speed up pdf generation in Jasper:

 

<property name="net.sf.jasperreports.export.pdf.compressed" value="true"/>

<subreport isUsingCache="true">

<image isUsingCache="true">

 

Aside from that, you can try optimizing your SQL: re-evaluate your joins, enable indexes, etc. Keep in mind, there are two major performance hits: database queries and pdf generation.

[prashantckc]

How we are going to set these value in Java COde?

Regarding the Query its a simple SELECT  * FROM TABLE