Subject Bug in monitoring tables with stored procs?
Author Douglas Tosi
Hello!

Using FB 2.1.1 64bit Windows, create a dummy stored procedure:

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.

Why the io_stats and record_stats for stored procedures are not being
accounted at the statement level?
Is this a bug or a design decision?

thanks,
--
Douglas Tosi
www.sinatica.com