Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JasperReports fillReport too slow and resource consuming

I've found that JasperReports is really slow when filling a report from a Java app. The program hangs at this line:

print = JasperFillManager.fillReport(report, parameters, xmlDataSource);

It usually stays there for 3 minutes, consuming up to 300Mb of RAM and 50% CPU.

  • report is a compiled (.jasper) report that uses 3 subreports.
  • The datasource is a pretty big XML file (about 100k lines, 1.5Mb)
  • The machine is a 3Ghz dual core with 4Gb of RAM

So, how can I improve report filling performance?

like image 214
Salvatorelab Avatar asked Apr 08 '13 09:04

Salvatorelab


1 Answers

The Problem

It seems that the problem is the XPath engine. That is, the library that parses the XML file looking for data.

While iReport Designer uses Jaxen, JasperReport uses Xalan. Xalan is really slow compared to Jaxen (really really slow).

That's why the problem only occurs when filling the report from a Java application and not from iReports.

The Solution

Well, the solution is simple, just add the following line in your Java application to select Jaxen lib instead of the default Xalan lib (it's deprecated, but it works):

JRProperties.setProperty("net.sf.jasperreports.xpath.executer.factory",
    "net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory");

EDIT: That line was deprecated, I've found the correct way to set properties:

DefaultJasperReportsContext context = DefaultJasperReportsContext.getInstance();
JRPropertiesUtil.getInstance(context).setProperty("net.sf.jasperreports.xpath.executer.factory",
    "net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory");

You will also need to add the Jaxen .jar to your build path. Here is a link: https://mvnrepository.com/artifact/jaxen/jaxen


While the report filling was taking 3-5 minutes with Xalan, it now completes in just a few seconds with Jaxen.

The answer was found here: http://community.jaspersoft.com/questions/536842/jasperreports-too-slow
And also here: http://community.jaspersoft.com/wiki/xml-data-source-very-slow-parse

like image 63
Salvatorelab Avatar answered Sep 20 '22 17:09

Salvatorelab