Community
Participate
Working Groups
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
Could you provide report design. We tried similar report but it seems doesn't has such issue?
Sorry, please ignore previous comment. Could you attach your report so we can check if there is some performance issue.
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.
