irfa

Hi Again same problem. But now query return only 1 row. It seams that query from report does not use index. I can find it in mysqld-slow.log file. Row sent: 1 , Row_examined: more then 39M In mysql workbench its fast, with "explain select..." i can see that use index.

Not regarding for this issue: Is MaxPermSize important for report fill time? Do I need to increase my PermSize for better performance? I have some reports with graphics taking more time to fill. About this. Im already using JConnect Driver. It wasn't last version, but nothing changed with new. I try with MariaDB and its same. Ill try now with logging.

query taking most of the time. When i run report, Im looking in mysql with "show processlist" and take about 8 sec to execute. Same query directly in mysql execute in less than 1 sec

Hi Im using jr-server 5.5.0 with MySQL on Linux. When I execute query in db its working fast. But when i put same query in report, db take much more time to process it and return to jr server. Query returns 7084 rows in more then 700 pages. My tomcat config: /opt/jasperreports-server-cp-5.5.0a/java/bin/java -Djava.util.logging.config.file=/opt/jasperreports-server-cp-5.5.0a/apache-tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms1024m -Xmx2048m -XX:PermSize=32m -XX:MaxPermSize=512m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Djava.awt.headless=true -Djava.endorsed.dirs=/opt/jasperreports-server-cp-5.5.0a/apache-tomcat/endorsed -classpath /opt/jasperreports-server-cp-5.5.0a/apache-tomcat/bin/bootstrap.jar:/opt/jasperreports-server-cp-5.5.0a/apache-tomcat/bin/tomcat-juli.jar -Dcatalina.base=/opt/jasperreports-server-cp-5.5.0a/apache-tomcat -Dcatalina.home=/opt/jasperreports-server-cp-5.5.0a/apache-tomcat -Djava.io.tmpdir=/opt/jasperreports-server-cp-5.5.0a/apache-tomcat/temp I try to replace <bean id="fileVirtualizerFactory" class="com.jaspersoft.jasperserver.api.engine.common.service.impl.FileVirtualizerFactory"> <property name="maxSize" value="300"/> <property name="directory" value="${java.io.tmpdir}"/> </bean> with <bean id="fileVirtualizerFactory" class="com.jaspersoft.jasperserver.api.engine.common.service.impl.GZipVirtualizerFactory"> <property name="maxSize" value="700"/> </bean> and it wasn't better

Hi All I have report with lot of input controls. First are two dates and most commonly used and it returs all records. But when i want to use another IC to filter, can I avoid new database search? Maybe to have subdataset to somehow access to main dataset when i want to filter with more inputs? Can i make something like that in Jaspesoft Studio? I have new version installed. Thanks