03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.27050 64 bits > Windows Server 2012R2 > > ¿Is there a way to calculate the effectiveness of incrementing the page cache > buffer ?
select cast(mon$page_reads as double precision)/mon$page_fetches from mon$io_stats where mon$stat_group=0 If the value is getting lower - you are on the right way. -- WBR, SD.
