Subject RE: Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed?
Author
---In firebird-support@yahoogroups.com, <liviuslivius@...> wrote:


> My pagesize is 16k and pages cache is set to 65536. And this can not be that.
> I see in MON$PAGE_READS small value = 585 but in MON$PAGE_FETCHES value = 120637.
> Database have 6685 pages what is corelated with real db size = ~104MB

  Oops, i mixed reads vs fetches :) Fetch is access to the page in page cache. To process (select)
one *row*, Fierbird need to make 2 fetches at least, for example. So, i see nothing strange here.

Regards,
Vlad