11. Supercharging FirebirdSQL

Tuning parameters in firebird.conf base on Firebird 2.5 64 bits

DefaultDbCachePages

- SuperServer - 9999 (Best Performance)

- SuperClassic - 512 (Best Performance)

TempCacheLimit

- SuperServer - 967108864 (Best Performance)

- SuperClassic - 67108864 (Default)

LockMemSize

- SuperServer - 1048576 (Default)

- SuperClassic - 5048576 (Best Performance)

LockHashSlots

- SuperServer - 1009 (Default)

- SuperClassic - 30011 (Best Performance)

Original Source :

- http://ib-aid.com/en/articles/tuning-1-7-terabyte-firebird-sql-database/

- http://ib-aid.com/en/optimized-firebird-configuration/