XML datasource slow

[jonnyfrastovner]

Hi,

I am facing performance issues in an xpath query. The documents are structured as defined in the attached xsd. My testfile is about 2MB - 3000 nodes.I define the query as

descendant::FeilMelding

 

The report query window instantly recognizes 3000 nodes. I define two fields, as @type and @grad. Filling a query outputting the two fields takes about 18 seconds, and adding new fields slows the query down further. I have defined sorting of the two fields in the "sort options" window, but it does not seem to impact performance much.

 

Is this performance as expected? I have a rather fast pc. I have tried to define an alternative query executor, as suggested elsewhere:

net.sf.jasperreports.xpath.executer.factory=net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory

but ireport gives this error:

net.sf.jasperreports.engine.JRException:Ânet.sf.jasperreports.engine.JRRuntimeException:Ânet.sf.jasperreports.engine.JRException:ÂClassÂ"net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory"ÂshouldÂbeÂcompatibleÂwithÂ"net.sf.jasperreports.engine.query.JRQueryExecuterFactory"

[lukassoftware]

jonnyfrastovner
Wrote:

Hi, I am facing performance issues in an xpath query. The documents are structured as defined in the attached xsd. My testfile is about 2MB - 3000 nodes.I define the query as descendant::FeilMelding The report query window instantly recognizes 3000 nodes. I define two fields, as @type and @grad. Filling a query outputting the two fields takes about 18 seconds, and adding new fields slows the query down further. I have defined sorting of the two fields in the "sort options" window, but it does not seem to impact performance much. Is this performance as expected? I have a rather fast pc. I have tried to define an alternative query executor, as suggested elsewhere: net.sf.jasperreports.xpath.executer.factory=net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory but ireport gives this error: net.sf.jasperreports.engine.JRException:�net.sf.jasperreports.engine.JRRuntimeException:�net.sf.jasperreports.engine.JRException:�Class�"net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory"�should�be�compatible�with�"net.sf.jasperreports.engine.query.JRQueryExecuterFactory"

i have the same problem.

Can someone help me ??

 

Regards,

Mathias