Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

04.05.2018 11:42, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > the single badly designed query with many page fetches can "improve" this > parameter a lot, > without any real improvement in the performance, of course. The question was about cache effectiveness which is always

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

I am totally agree with Mark. Ratio of page reads/page fetches for all queries has a little sense. For example, the single badly designed query with many page fetches can "improve" this parameter a lot, without any real improvement in the performance, of course. Regards, Alexey Kovyazin

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

On 3-5-2018 15:52, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > > > Thank you very much! You shouldn't focus purely on this metric, greater page caches may lead to more pages returned from memory, but also increase memory consumption and overhead from things like cache

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

Thank you very much!On Thursday, May 3, 2018, 3:30:32 AM CDT, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote:   03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.27050 64 bits >

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

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

[firebird-support] Measure the effectiveness of incrementing page buffer...

Firebird ver 2.5.7.27050 64 bitsWindows Server 2012R2 ¿Is there a way to calculate the effectiveness of incrementing the page cache buffer ? thanks in advance