|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Tested with FB 2.1.1 64 bit on Vista 64bit
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
create procedure dummy
returns (i bigint)
as
begin
select count(*)
from big_table /* my test is 3.5 million records */
into :i;
suspend;
end
Now select i from dummy;
The statistics for this statement should show a lot of page_reads.
But mon$io_stats always show zero.
Curiously, the io_stats for the transaction and for the attachment did
show a correct increase in page_reads.
|
|
Description
|
create procedure dummy
returns (i bigint)
as
begin
select count(*)
from big_table /* my test is 3.5 million records */
into :i;
suspend;
end
Now select i from dummy;
The statistics for this statement should show a lot of page_reads.
But mon$io_stats always show zero.
Curiously, the io_stats for the transaction and for the attachment did
show a correct increase in page_reads.
|
Show » |
|
Bug
I/O statistics for stored procedures are not accounted in monitoring tables