Eclipse Community Forums: BIRT » IGetParameterDefinitionTask getSelectionList get too time during evaluation

Home » Archived » BIRT » IGetParameterDefinitionTask getSelectionList get too time during evaluation(getSelectionList() is terrible slow )

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

IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #785270]

Sat, 28 January 2012 19:11

Alessio Pollero

Messages: 74
Registered: August 2011

Member

I'm debugging my program that make use of the API to generate reports, and i noticed that when i call the method getSelectionList() of the IGetParameterDefinitionTask interface it is very slow, following some example :

Loaded new Selection list, loading time=17ms
Loaded new Selection list, loading time=960ms
Loaded new Selection list, loading time=3ms
Loaded new Selection list, loading time=1ms
Loaded new Selection list, loading time=240ms
Overall loading time=1422ms

as you can see the second parameter takes 960ms when the query associated with it get executed pretty fast :

7 rows in set (0.00 sec)

I have tried even removing the ORDER BY clause from the SQL query and move the sort to the parameter definition and the result is even worse :

Loaded new Selection list, loading time=14ms
Loaded new Selection list, loading time=1528ms
Loaded new Selection list, loading time=2ms
Loaded new Selection list, loading time=1ms
Loaded new Selection list, loading time=253ms
Overall loading time=1974ms

As you can see it gets 1,5 seconds to get the Selection List for a simple dynamic parameter linked with a dataset that execute a very lightweight SQL Query on a MySQL database that have only 7 rows as result set ...

Is there a way to improve performance ? How ?

Could be a bug of BIRT API ? I'm using version 3.7.1

Report message to a moderator

Re: IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #786625 is a reply to message #785270]

Mon, 30 January 2012 16:45

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Is this a simple selection list or a cascaded parameter?

Jason

On 1/28/2012 2:11 PM, Alessio Pollero wrote:
> I'm debugging my program that make use of the API to generate reports,
> and i noticed that when i call the method
> http://help.eclipse.org/indigo/index.jsp?topic=%2Forg.eclipse.birt.doc.isv%2Fengine%2Fapi%2Forg%2Feclipse%2Fbirt%2Freport%2Fengine%2Fapi%2FIGetParameterDefinitionTask.html
> of the IGetParameterDefinitionTask interface it is very slow, following
> some example :
>
> Loaded new Selection list, loading time=17ms
> Loaded new Selection list, loading time=960ms
> Loaded new Selection list, loading time=3ms
> Loaded new Selection list, loading time=1ms
> Loaded new Selection list, loading time=240ms
> Overall loading time=1422ms
>
> as you can see the second parameter takes 960ms when the query
> associated with it get executed pretty fast :
> 7 rows in set (0.00 sec)
>
> I have tried even removing the ORDER BY clause from the SQL query and
> move the sort to the parameter definition and the result is even worse :
>
> Loaded new Selection list, loading time=14ms
> Loaded new Selection list, loading time=1528ms
> Loaded new Selection list, loading time=2ms
> Loaded new Selection list, loading time=1ms
> Loaded new Selection list, loading time=253ms
> Overall loading time=1974ms
>
> As you can see it gets 1,5 seconds to get the Selection List for a
> simple dynamic parameter linked with a dataset that execute a very
> lightweight SQL Query on a MySQL database that have only 7 rows as
> result set ...
>
> Is there a way to improve performance ? How ?
>
> Could be a bug of BIRT API ? I'm using version 3.7.1

Report message to a moderator