| Subject | Re: [firebird-support] Measure the effectiveness of incrementing page buffer... |
|---|---|
| Author | Javier Cintron |
| Post date | 2018-05-03T13:52:30Z |
Thank you very much!
On Thursday, May 3, 2018, 3:30:32 AM CDT, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
03.05.2018 7:56, Javier Cintron fcintrono@... [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.