Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » IGetParameterDefinitionTask getSelectionList get too time during evaluation(getSelectionList() is terrible slow )
icon4.gif  IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #785270] Sat, 28 January 2012 19:11 Go to next message
Alessio Pollero is currently offline Alessio Pollero
Messages: 66
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
Re: IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #786625 is a reply to message #785270] Mon, 30 January 2012 16:45 Go to previous messageGo to next message
Jason Weathersby is currently offline 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
Re: IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #786831 is a reply to message #786625] Mon, 30 January 2012 21:27 Go to previous messageGo to next message
Alessio Pollero is currently offline Alessio Pollero
Messages: 66
Registered: August 2011
Member
A Simple selection list .
Re: IGetParameterDefinitionTask getSelectionList get too time during evaluation [message #787455 is a reply to message #786831] Tue, 31 January 2012 15:45 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

If you run the query separately does it take this long?

Jason

On 1/30/2012 4:27 PM, Alessio Pollero wrote:
> A Simple selection list .
Previous Topic:Share one single rptlibrary for a tree of Reports
Next Topic:Using connection profiles with Weblogic
Goto Forum:
  


Current Time: Mon Sep 22 16:27:35 GMT 2014

Powered by FUDForum. Page generated in 0.02440 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software