Community
Participate
Working Groups
Build Identifier: birt-runtime-2_6_0 I am using mysql 5.1.43-community-log MySQL Community Server (GPL) as back-end. Tomcat 6.0.24 as the server and java 1.6.0_18. Database contains about 2 million records. Reports are configured to show 100 records per page. I development on small record-set it works well but on showing 2 million records it stucks in processing, like it does not support server side pagination. Reproducible: Always Steps to Reproduce: 1.Create table tbl and populate it with 2 million records 2.Create detail report and attach it with that table 3.View this report in web viwer.
(In reply to comment #0) > Build Identifier: birt-runtime-2_6_0 > > I am using mysql 5.1.43-community-log MySQL Community Server (GPL) as back-end. > Tomcat 6.0.24 as the server and java 1.6.0_18. Database contains about 2 > million records. Reports are configured to show 100 records per page. I > development on small record-set it works well but on showing 2 million records > it stucks in processing, like it does not support server side pagination. > > Reproducible: Always > > Steps to Reproduce: > 1.Create table tbl and populate it with 2 million records > 2.Create detail report and attach it with that table > 3.View this report in web viwer. I can not reproduce this issue with webviewerexample 2.6.0 release + mysql + tomcat 6.0 + jdk1.6. It takes 10 mins to render the report since the result set is quite large (2,175,320 records). Tomcat setting: set JAVA_OPTS=-server -Xmx2048m -Xms128m -XX:MaxPermSize=256m
