HTML 5 Chart taking more time to load for aggregation queries

[kamalini.athmarao]

We have upgraded from Jasper 5.6 to Jasper 6.1. Few reports, performance has been degraded after the upgrade. 

After analysis, its been noticed that, if report is designed with 'List Aggregate' functions in SQL, Report load time is more compared to other queries. Also, components like chart or table or crosstab further increases report execution time. 

Please guide to increase the performance of the report. 

 

[kkriplani]

Hi,

In <tomcat>/conf/server.xml , you will find a <connector .... /> Tag. Replace the complete tag with :
 

<Connector compressableMimeType="text/html,text/xml,text/css,text/javascript, application/x-javascript,application/javascript"
compression="on"
compressionMinSize="128"
connectionTimeout="20000"
noCompressionUserAgents="gozilla, traviata"
port=" ***** "
maxHttpHeaderSize="65536"
redirectPort=" **** " protocol="HTTP/1.1" />

Note: Replace the stars with relevant connector port and redirect port.

This is a way to tune your tomcat, go through the following link to learn about more ways to tune you tomcat.

Regards,
KKriplani
 

[kamalini.athmarao]

Thanks for your Response. This settings didnt help out. 

Issue is happening only when the report or chart component query uses "List Aggregate" function. 

Has anyone tried creating a report with list aggregate function in sql.