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

Bug 363766

Summary:	Report Performance
Product:	z_Archived	Reporter:	Sudheendra Walvekar <walvekars>
Component:	BIRT	Assignee:	Birt-DataAccess <Birt-DataAccess-inbox>
Status:	NEW ---	QA Contact:	Sissi Zhu <szhu>
Severity:	normal
Priority:	P3	CC:	bluesoldier, jouyang, lchen
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:

Description Sudheendra Walvekar

2011-11-15 00:39:34 EST

Build Identifier: M20110210-1200

To build BIRT report, I use eclipse designer.I use MySQL to store the data.I am building a simple list report which has 125 columns. About half of them are of type string and rest of them are of type decimal.To fetch 5000 rows, the designer takes about 10 minutes when previewed. To fetch the same records, other application like MySQL workbench takes few seconds. Can you suggest how this can be resolved.

Reproducible: Always

Steps to Reproduce:
1.Create table with 125 columns( or I can send the dump of the table)
2.Choose a blank report from the designer to create the report
3.Run the report

Comment 1 Liwen Chen

2011-12-30 03:24:25 EST

Could you provide  report design.

We tried similar report but it seems doesn't has such issue?

Comment 2 Liwen Chen

2011-12-30 03:29:18 EST

Sorry, please ignore previous comment.
Could you attach your report so we can check if there is some performance issue.

Comment 3 Jun Ouyang

2011-12-30 03:34:16 EST

Please notice that birt response time can't be simply compared with MYSQL workbench, because MYSQL workbench just retrieve data, while BIRT needs to retrieve data, format them, calculate layout, calculate styles, run dynamic scripts, etc. All these operations are not fast.

Anyway, please provide your report design and information of your computer, so that we can evaluate if it's a performance bug.