PerformanceandSizingforBIRTReportsandBusinessReports-Actuate.ppt

Designing High Performance BIRT Reports Mica J. Block Director Actuate Corporate Engineers Actuate Corporation Topics Understanding generation performance External factors Overhead Estimated Component Times Performance tips Generation Rendering NOTE: This presentation deals with the performance of the reports themselves regardless of the server technology being used. Understanding Performance “Pages-per-Second” Myth Assumes all reports are equal Ignores Number of report items per page Complexity of the query Pages are defined at render time Impact of aggregates, and more… Reality: report items-per-second is better metric Pages-per-second applies only to same report on different runs External Factors System: CPU, load Raw CPU power RAM Overall load in server environment JVM User expectations DB performance Database design Query design optimization Performance of vendor’s query features Network overhead Actuate Architecture Estimated Component Times Estimated from simple listing using single table (10,000 rows) in SQL Server Generation only does not include rendering Not scientific methodology (done on a laptop) Your mileage will vary Use your own data Try in your own environment Focus on specific reports with problems Estimated Component Times Pages: little to no effect Changed page break from 200 to 100 -- double pages Adds 2% to report run Formatting: little to no effect Added numeric and date formatting Was slightly faster Groups: moderate to significant Add two group levels to simple listing Adds ~5-20% to report run per group Depends on the number of group breaks Depends on how the data is sorted Estimated Component Times One-pass aggregates: moderate Added two aggregates Adds ~4% per aggregate to report run Depends on number of groups Look-ahead aggregates: significant Total for group as percent of overall total Adds ~2-8% per aggregate to report run Depends on number of groups and number of data items Charts: Very significant One chart added ~33% to re