---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
