Hello, karolbieniaszewski!

Monday, October 17, 2011, 11:07:00 AM, you wrote:

k> --- In firebird-support@yahoogroups.com, "ramix001" <ramix001@...> wrote:

>> For Classic/SuperClassic-Server:
>> (Physical RAM in KB / default page size in KB) * 0.005 (0.5% of total RAM).

k> SuperServer - for classic you mast modify formula and add whole conections count in place
k> where count of running databases are

I suggest not to use any "formulas" for Classic/SuperClassic.
Classic architecture performance degrades when cache is increased, and
there are lot of connections (processes).
So, it is worst idea to set cache size for classic going from free
amount of RAM. Otherwise, for Classic RAM is a parameter of "how many
connections can we made". For Superclassic also, and 32-bit
superclassic can't handle more than 2gb of RAM.

Currenlty best cache size for Classic is 2048 pages.
Which with 16k page means 32mb. For some systems it may be too much,
and needed to be lowered to 1024 pages or even 512 pages.
Unfortunately, you can understand the optimum cache size for Classic only
by experiment.

--
Dmitry Kuzmenko, www.ib-aid.com