Subject Re: Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed?
Author Tim Ward
Post date 2013-12-13T09:15:39Z
In case this helps anyone else ...

For x records it's usual to see 2x fetches. If this creeps up to 3x fetches and your application slows down by several orders of magnitude it may be that you have fragmented records, with each record split across two or more pages.

On 12/12/2013 14:59, liviuslivius@... wrote:
 

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


-- 
Tim Ward