Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 324509

Summary: Large Dataset with detail report does not show on report viewer.
Product: z_Archived Reporter: Noman <mnomikhan>
Component: BIRTAssignee: Birt-ReportViewer <Birt-ReportViewer-inbox>
Status: RESOLVED WORKSFORME QA Contact:
Severity: normal    
Priority: P3 CC: bluesoldier
Version: unspecified   
Target Milestone: 3.7.0   
Hardware: PC   
OS: Windows 7   
Whiteboard:

Description Noman CLA 2010-09-04 06:00:04 EDT 
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.
Comment 1 Xiaoying Gu CLA 2011-03-18 01:53:14 EDT 
(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