Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » what is doing between a dataset afterOpen event and onFetch event?
what is doing between a dataset afterOpen event and onFetch event? [message #702242] Tue, 26 July 2011 02:10 Go to next message
tong123123 tong123123 is currently offline tong123123 tong123123
Messages: 74
Registered: April 2011
Member
I have a report and from the debug message, I found a dataset need 14 minutes (from 14:26 to 14:40) to transfer from afterOpen event to onFetch event.
I want to know what is doing between a dataset afterOpen event and the same dataset onFetch event? I feel 14 minutes is too long and do not know what is the report doing during this phase.

My birt designer version is 2.2.1.r221_v20070924

attach is the report, the problematic dataset is "SingleServerDiskUtilization_Unix"

sample debug message output from eclipsec.exe is as following
Quote:

end of disk beforeOpen event
Disk afterOpen event : Tue Jul 26 2011 14:26:14 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk onFetch event : Tue Jul 26 2011 14:40:39 GMT+0800 (CST)
Disk beforeClose event : Tue Jul 26 2011 14:40:40 GMT+0800 (CST)
Disk afterClose event : Tue Jul 26 2011 14:40:40 GMT+0800 (CST)

[Updated on: Tue, 26 July 2011 04:00]

Report message to a moderator

Re: what is doing between a dataset afterOpen event and onFetch event? [message #703234 is a reply to message #702242] Wed, 27 July 2011 06:37 Go to previous messageGo to next message
tong123123 tong123123 is currently offline tong123123 tong123123
Messages: 74
Registered: April 2011
Member
Anyone can help?
is the sql already completely run between dataset beforeOpen and dataset afteropen event? or is the sql still running after dataset afterOpen event?
Or between dataset afterOpen and onFetch event is the time to fill up the fields of the dataset after database data is fetched?
(no subject) [message #703420 is a reply to message #703234] Wed, 27 July 2011 10:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

The order is like this:
jdbc open
Dataset beforeOpen event
jdbc new query
jdbc prepare query
Dataset afterOpen event
jdbc execute query - all results are returned here.
Dataset onFetch for each result

Jason


On 7/27/2011 6:37 AM, tong123123 wrote:
> Anyone can help?
> is the sql already completely run between dataset beforeOpen and dataset
> afteropen event? or is the sql still running after dataset afterOpen event?
> Or between dataset afterOpen and onFetch event is the time to fill up
> the fields of the dataset after database data is fetched?


Jason Weathersby

BIRT Exchange
Re: (no subject) [message #703469 is a reply to message #703420] Wed, 27 July 2011 11:48 Go to previous messageGo to next message
tong123123 tong123123 is currently offline tong123123 tong123123
Messages: 74
Registered: April 2011
Member
Quote:

Dataset afterOpen event
jdbc execute query - all results are returned here.
Dataset onFetch for each result


oh, that means the 14 minutes between dataset afterOpen events and onFetch events is used for execute the query?!!
if I extract the sql and run on database client, it need to run about 14 minutes? (I am at home now and cannot test this in office server).
Re: (no subject) [message #703518 is a reply to message #703469] Wed, 27 July 2011 12:38 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

It is preparing the query to get metadata for column types and then
running the query. 14 minutes seems excessive. How complex is the query?

Jason

On 7/27/2011 11:48 AM, tong123123 wrote:
> Quote:
>> Dataset afterOpen event
>> jdbc execute query - all results are returned here.
>> Dataset onFetch for each result
>
>
> oh, that means the 14 minutes between dataset afterOpen events and
> onFetch events is used for execute the query?!!
> if I extract the sql and run on database client, it need to run about 14
> minutes? (I am at home now and cannot test this in office server).


Jason Weathersby

BIRT Exchange
Previous Topic:Multiple Submit Buttons in Custom Parameter Page
Next Topic:Pentaho Metadata Editor as an ODA datasource
Goto Forum:
  


Current Time: Thu Apr 24 06:25:40 EDT 2014

Powered by FUDForum. Page generated in 0.01520 seconds