Subject Re: [firebird-support] Re: How to find out buffer size.
Author Ivan Prenosil
Alexandre Benson Smith wrote:
> Reduce de Cache Size to something between 8000-10000. There is a known
> 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

The number 10000 is just myth.
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/