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/