what is doing between a dataset afterOpen event and onFetch event? [message #702242] |
Tue, 26 July 2011 06:10 |
Missing name Mising name Messages: 81 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 08:00] Report message to a moderator
|
|
|
|
(no subject) [message #703420 is a reply to message #703234] |
Wed, 27 July 2011 14:35 |
|
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 #703518 is a reply to message #703469] |
Wed, 27 July 2011 16:38 |
|
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).
|
|
|
Powered by
FUDForum. Page generated in 0.02908 seconds