Hi, Thanks you very much i see that i misunderstand fetches fetchesield previously. Now it is clear - for 59732 records it is possible to have 120637 fetches :)
Regards, Karol Bieniaszewski ----- Reply message ----- Od: [email protected] Do: <[email protected]> Temat: Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed? Data: czw., gru 12, 2013 14:52 ---In [email protected], <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
