Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » BIRT performance

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT performance [message #170693]

Thu, 15 June 2006 15:59

Andrey Dulub

Messages: 54
Registered: July 2009

Member

Hello All,

How to increase BIRT performance as much as possible ? What the main keys of
its performance ?
In my case, I'm trying simple report based on two SQL queries. Count of
records in selected tables no more then 50. Time of the report generation
is unacceptable :
2 seconds on engine init ;
2 seconds on data source init ;
2-3 seconds on HTML rendering (first rendering - 5 seconds, next 1-2).
Are there any common advices ?

My environment - Eclipse 3.2M5a, birt-runtime-2.1RC4

Thanks in advance,
Andrey Dulub

Report message to a moderator

Re: BIRT performance [message #173776 is a reply to message #170693]

Tue, 27 June 2006 13:35

Andrey Dulub

Messages: 54
Registered: July 2009

Member

I don't believe that nobody faced a problem of the BIRT performance.
I would like to hear opinions other developers about this issue and their
steps in this direction.
My steps were:
1. Compile all *.rptdesign files into *.rptdocument
2. Create registry of IReportDocument during report engine startup
3. Use IRenderTask with pool/reuse
4. Simplify report design - less elements, minimize data sets
5. Turn off logging

Something else ?

Thanks in advance,
Andrey Dulub

"Andrey Dulub" <adulub@gmail.com> wrote in message
news:e6s052$566$1@utils.eclipse.org...
> Hello All,
>
> How to increase BIRT performance as much as possible ? What the main keys
> of its performance ?
> In my case, I'm trying simple report based on two SQL queries. Count of
> records in selected tables no more then 50. Time of the report
> generation is unacceptable :
> 2 seconds on engine init ;
> 2 seconds on data source init ;
> 2-3 seconds on HTML rendering (first rendering - 5 seconds, next 1-2).
> Are there any common advices ?
>
> My environment - Eclipse 3.2M5a, birt-runtime-2.1RC4
>
> Thanks in advance,
> Andrey Dulub
>

Report message to a moderator

Re: BIRT performance [message #173945 is a reply to message #170693]

Wed, 28 June 2006 01:19

Liyan Hu

Messages: 6
Registered: July 2009

Junior Member

Hi, I'm also concerned about the BIRT performance although I don't know
how to improve it yet. It takes 30 seconds for my report with 9 tables and
1 graphs to be loaded in birt report viewer. Can you tell me how did you
log the time in each phase of report generation? Or is it just an
estimation? Thanks.

Report message to a moderator

Re: BIRT performance [message #174617 is a reply to message #173945]

Sat, 01 July 2006 14:48

Andrey Dulub

Messages: 54
Registered: July 2009

Member

I'm working with BIRT through API.
So, I can track any phase of report generation.
Furthermore, report angine supports tunable logging.

Good luck,
Andrey Dulub

"Liyan Hu" <liyanhu2001@yahoo.com.au> wrote in message
news:441db3d4b537e29750ca47561cf982ff$1@www.eclipse.org...
> Hi, I'm also concerned about the BIRT performance although I don't know
> how to improve it yet. It takes 30 seconds for my report with 9 tables and
> 1 graphs to be loaded in birt report viewer. Can you tell me how did you
> log the time in each phase of report generation? Or is it just an
> estimation? Thanks.
>

Report message to a moderator

Re: BIRT performance [message #199451 is a reply to message #173776]

Mon, 06 November 2006 21:04

Eclipse User

Originally posted by: lingtai.earthlink.net

Andrey;

I would like to use your approach to tackle BIRT performance. But, I am
not quite sure what do you mean by "Compile all *.rptdesign files into
*.rptdocument".

Do you mean to write a Java Application that uses the report engine API
to create .rptdocument files as shown below or there are other ways to
convert a rptdesign file to a rptdocument file?

//open the report design
IReportRunnable design = null;
design = engine.openReportDesign(REPORT_DESIGN);

//Create a task to run the report
IRunTask task = engine.createRunTask(design);

//Run the report and create the rptdocument
task.run(REPORT_DOCUMENT);

//Open the rptdocument
IReportDocument rptdoc = engine.openReportDocument(REPORT_DOCUMENT);

Many thanks,
Ling

> Andrey Dulub wrote:
> I don't believe that nobody faced a problem of the BIRT performance.
> I would like to hear opinions other developers about this issue and their
> steps in this direction.
> My steps were:
> 1. Compile all *.rptdesign files into *.rptdocument
> 2. Create registry of IReportDocument during report engine startup
> 3. Use IRenderTask with pool/reuse
> 4. Simplify report design - less elements, minimize data sets
> 5. Turn off logging
>
> Something else ?
>
> Thanks in advance,
> Andrey Dulub
>
> "Andrey Dulub" <adulub@gmail.com> wrote in message
> news:e6s052$566$1@utils.eclipse.org...
>> Hello All,
>>
>> How to increase BIRT performance as much as possible ? What the main keys
>> of its performance ?
>> In my case, I'm trying simple report based on two SQL queries. Count of
>> records in selected tables no more then 50. Time of the report
>> generation is unacceptable :
>> 2 seconds on engine init ;
>> 2 seconds on data source init ;
>> 2-3 seconds on HTML rendering (first rendering - 5 seconds, next 1-2).
>> Are there any common advices ?
>>
>> My environment - Eclipse 3.2M5a, birt-runtime-2.1RC4
>>
>> Thanks in advance,
>> Andrey Dulub
>>
>
>

Report message to a moderator

Previous Topic:	NullPointerException in buildDataSource
Next Topic:	Setting scale of a chart by script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 20 01:13:50 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter