Eclipse Community Forums: BIRT » what is doing between a dataset afterOpen event and onFetch event?

Home » Archived » 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

Eclipse User

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)

Attachment: ADM00001_System_Resource_Utilization_Single_Heat_Chart.rptdesign
(Size: 749.57KB, Downloaded 374 times)

[Updated on: Tue, 26 July 2011 04:00] by 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

Eclipse User

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

Eclipse User

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?

Re: (no subject) [message #703469 is a reply to message #703420]

Wed, 27 July 2011 11:48

Eclipse User

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

Eclipse User

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).

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 17:47:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter