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

2018-05-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
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 measured as "hit 
ratio", not 
about abstract "performance" which has no formal metrics.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

2018-05-04 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support] 


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
IBSurgeon www.ib-aid.com





On 04.05.2018 12:29, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:


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 eviction/coordination in the case of
Classic / SuperClassic (where the cache is per connection).

Mark

> 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
> > 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.
>
>
>
>

--
Mark Rotteveel

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

2018-05-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
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 eviction/coordination in the case of 
Classic / SuperClassic (where the cache is per connection).

Mark

> 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
>  > 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.
> 
> 
> 
> 


-- 
Mark Rotteveel

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

2018-05-03 Thread Javier Cintron fcintr...@yahoo.com [firebird-support] 
 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
> 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.

  #yiv1296759600 #yiv1296759600 -- #yiv1296759600ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1296759600 
#yiv1296759600ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1296759600 
#yiv1296759600ygrp-mkp #yiv1296759600hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1296759600 #yiv1296759600ygrp-mkp #yiv1296759600ads 
{margin-bottom:10px;}#yiv1296759600 #yiv1296759600ygrp-mkp .yiv1296759600ad 
{padding:0 0;}#yiv1296759600 #yiv1296759600ygrp-mkp .yiv1296759600ad p 
{margin:0;}#yiv1296759600 #yiv1296759600ygrp-mkp .yiv1296759600ad a 
{color:#ff;text-decoration:none;}#yiv1296759600 #yiv1296759600ygrp-sponsor 
#yiv1296759600ygrp-lc {font-family:Arial;}#yiv1296759600 
#yiv1296759600ygrp-sponsor #yiv1296759600ygrp-lc #yiv1296759600hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1296759600 
#yiv1296759600ygrp-sponsor #yiv1296759600ygrp-lc .yiv1296759600ad 
{margin-bottom:10px;padding:0 0;}#yiv1296759600 #yiv1296759600actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1296759600 
#yiv1296759600activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1296759600
 #yiv1296759600activity span {font-weight:700;}#yiv1296759600 
#yiv1296759600activity span:first-child 
{text-transform:uppercase;}#yiv1296759600 #yiv1296759600activity span a 
{color:#5085b6;text-decoration:none;}#yiv1296759600 #yiv1296759600activity span 
span {color:#ff7900;}#yiv1296759600 #yiv1296759600activity span 
.yiv1296759600underline {text-decoration:underline;}#yiv1296759600 
.yiv1296759600attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1296759600 .yiv1296759600attach div a 
{text-decoration:none;}#yiv1296759600 .yiv1296759600attach img 
{border:none;padding-right:5px;}#yiv1296759600 .yiv1296759600attach label 
{display:block;margin-bottom:5px;}#yiv1296759600 .yiv1296759600attach label a 
{text-decoration:none;}#yiv1296759600 blockquote {margin:0 0 0 
4px;}#yiv1296759600 .yiv1296759600bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1296759600 
.yiv1296759600bold a {text-decoration:none;}#yiv1296759600 dd.yiv1296759600last 
p a {font-family:Verdana;font-weight:700;}#yiv1296759600 dd.yiv1296759600last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1296759600 
dd.yiv1296759600last p span.yiv1296759600yshortcuts 
{margin-right:0;}#yiv1296759600 div.yiv1296759600attach-table div div a 
{text-decoration:none;}#yiv1296759600 div.yiv1296759600attach-table 
{width:400px;}#yiv1296759600 div.yiv1296759600file-title a, #yiv1296759600 
div.yiv1296759600file-title a:active, #yiv1296759600 
div.yiv1296759600file-title a:hover, #yiv1296759600 div.yiv1296759600file-title 
a:visited {text-decoration:none;}#yiv1296759600 div.yiv1296759600photo-title a, 
#yiv1296759600 div.yiv1296759600photo-title a:active, #yiv1296759600 
div.yiv1296759600photo-title a:hover, #yiv1296759600 
div.yiv1296759600photo-title a:visited {text-decoration:none;}#yiv1296759600 
div#yiv1296759600ygrp-mlmsg #yiv1296759600ygrp-msg p a 
span.yiv1296759600yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1296759600 
.yiv1296759600green {color:#628c2a;}#yiv1296759600 .yiv1296759600MsoNormal 
{margin:0 0 0 0;}#yiv1296759600 o {font-size:0;}#yiv1296759600 
#yiv1296759600photos div {float:left;width:72px;}#yiv1296759600 
#yiv1296759600photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1296759600 
#yiv1296759600photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1296759600
 #yiv1296759600reco-category {font-size:77%;}#yiv1296759600 
#yiv1296759600reco-desc {font-size:77%;}#yiv1296759600 .yiv1296759600replbq 
{margin:4px;}#yiv1296759600 #yiv1296759600ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1296759600 #yiv1296759600ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1296759600 
#yiv1296759600ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1296759600 
#yiv1296759600ygrp-mlmsg select, #yiv1296759600 input, #yiv1296759600 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1296759600 
#yiv1296759600ygrp-mlmsg pre, #yiv1296759600 code {font:115% 
monospace;}#yiv1296759600

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

2018-05-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
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.