Bug 220888 - [Performance improvements] Report Generation Performance can be improved by modifying process for rptdocument
Summary: [Performance improvements] Report Generation Performance can be improved by m...
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.2.1   Edit
Hardware: PC Windows 2000
: P3 enhancement (vote)
Target Milestone: Future   Edit
Assignee: Wei Yan CLA
QA Contact:
URL:
Whiteboard:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2008-02-29 01:19 EST by Prashant CLA
Modified: 2009-05-28 16:42 EDT (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Prashant CLA 2008-02-29 01:19:43 EST
Hi,

I would like to request for adding functionlity for setting the parameters values before rendering the report.

Case study :
--------------------------------------------
After creating rptdocument, there are methods called setParametersXXX() which has no effect on output of the report. As I understand rptdocument itself has records stored in there, but then why methods for setting parameters are provided ? 

As I have tested one report with 2 simple group ons and listing rows and having 5000 rows, when i run for 1 user it takes around 30 secs on an average which is a bit high and when 10 users tries to generate report then all requests finishes in 3 mins.

Server details : 4 CPUs, 2 GB RAM 


Enhancement Request :
--------------------------------------------
I got some performance improvement after creating rptdocument but creating rptdocument doesnt solve purpose of providing report as per request parameters rpovided. Is it possible to have creation of rptdocument without any records. Compiling entire design file into rptdocument and leaving behind the process of retrieving records from database upon rendering. Or can we have similar compiled rptdocument for such usability to improve performance drastically over RunAndRenderTask and lower than RenderTask.


Thanks,
Prashant
Comment 1 Wenfeng Li CLA 2009-03-10 20:04:27 EDT
Without retrieving records from the database, BIRT engine will not have the data to layout the report, create paginations, and calculate report scripts. Without these calculations in engine, there is no much to saved into the report document.

Is it possible for you to profile the operation you have and share with us the bottleneck you have found?