Issue Details (XML | Word | Printable)

Key: CORE-2017
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Douglas Tosi
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

I/O statistics for stored procedures are not accounted in monitoring tables

Created: 28/Jul/08 10:25 AM   Updated: 29/Jun/11 11:39 AM
Component/s: Engine
Affects Version/s: 2.1.1
Fix Version/s: 2.1.2, 2.5 Beta 1

Time Tracking:
Not Specified

Environment: Tested with FB 2.1.1 64 bit on Vista 64bit
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
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.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 29/Jun/11 11:39 AM
Qa test added.