Javier Cintron asked:

Is there a way to calculate the effectiveness of incrementing the page cache buffer?

Dimitry Sibiryakov answers:

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.

Like this post? Share on: TwitterFacebookEmail


Related Articles


Author

Firebird Community

Published

Category

Gems from Firebird Support list

Tags