Subject | Re: [firebird-support] Re: How to find out buffer size. |
---|---|
Author | Ivan Prenosil |
Post date | 2007-01-08T19:46:39Z |
Alexandre Benson Smith wrote:
Actually there is no "magical" number of pages after it is slow.
The old algorithm simply means: the bigger cache, the slower.
The slowness is caused by "eating" more CPU power.
But this problem was discovered many years ago - with todays CPUs
you will hardly notice any difference.
(a year ago I tried to test whether the algorithm was improved
in FB1.5 or FB2, but the difference between FB1 and FB2 was so small
that it was not worth to remember the result)
Ivan
http://www.volny.cz/iprenosil/interbase/
> Reduce de Cache Size to something between 8000-10000. There is a knownThe number 10000 is just myth.
> limitation on the FB 1.X dirty page algorithm that tends to slow down
> with Cache Size greater than 10k. FB 2.0 can handle bigger caches
Actually there is no "magical" number of pages after it is slow.
The old algorithm simply means: the bigger cache, the slower.
The slowness is caused by "eating" more CPU power.
But this problem was discovered many years ago - with todays CPUs
you will hardly notice any difference.
(a year ago I tried to test whether the algorithm was improved
in FB1.5 or FB2, but the difference between FB1 and FB2 was so small
that it was not worth to remember the result)
Ivan
http://www.volny.cz/iprenosil/interbase/