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 :
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
|
|
|
Re: IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #786625 is a reply to message #785270] |
Mon, 30 January 2012 16:45 |
|
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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03849 seconds