Software/Scripts New Firebird SQL RMDBS optmized configurations files (v3.x, v2.5 and olders - 32/64bits)

[emailx45]

Optimized Firebird Configurations

Spoiler: Content

[SHOWTOGROUPS=4,20]

1. Home
2. Services
3. Optimized Firebird configurations

Here you can find a collection of optimized Firebird configuration files. We hope that these improved configuration files will help to resolve many typical performance problems with Firebird. In the 2nd edition of this collection (released March 23, 2020), we have created several optimized configurations for each architecture, to better fit various types of load.

Firebird 3
Select the architecture and then select the configuration file:
SuperServer: If you have 1 main database and, optionally, 2-5 smaller (and less loaded) databases on the server, choose SuperServer architecture and configure each database in databases.conf.

• Firebird 3 SuperServer configuration for server with RAM 8-12Gb with 3 databases:
  • firebird_30_superserver_64bit_ram8gb.conf, databases_30ss_8gb.conf (only 64 bit)
• Firebird 3 SuperServer configuration for server with RAM 16-32Gb with 3 databases:
  • firebird_30_superserver_64bit_ram16gb.conf, databases_30ss_16gb.conf (only 64 bit)

SuperClassic: if you have many databases on the server (from 10 to 1000), and they are more or less equal in terms of load, and your application is stable (i.e., you never saw “Abnormal termination” in firebird.log), choose SuperClassic. It is better than Classic in terms of better control of sorting memory and performance

• Firebird 3 SuperClassic configuration for server with RAM 8-12Gb with 10+ databases with 150 connections for all databases totally:
  • firebird_30_superclassic_64bit_8Gb.conf (only 64 bit)
• Firebird 3 SuperClassic configuration for server with RAM 16-32Gb with 10+ databases with 300 connections for all databases totally:
  • firebird_30_superclassic_64bit_16Gb.conf (only 64 bit)

Classic: if you have many databases (from 10 to 1000) on the server and they can be problematic in terms of stability, or if you have 32bit UDF, choose Classic.

• Firebird 3 Classic configuration for server with RAM 8-12Gb with 10+ databases with less than 150 connections totally:
  • firebird_30_classic_32bit_8Gb.conf 32bit,
  • firebird_30_classic_64bit_8Gb.conf 64 bit
• Firebird 3 Classic configuration for server with RAM 16-32Gb with 10+ databases with less than 300 connections totally:
  • firebird_30_classic_32bit_16Gb.conf 32bit,
  • firebird_30_classic_64bit_16Gb.conf 64 bit

Firebird 2.5
Select the architecture and configuration file:
SuperServer: if you have 1-2 database with small load (1-3 simultaneously active users, up to 20 users totally), and limited hardware resources, choose SuperServer.

• Firebird 2.5 SuperServer for server with RAM 4+Gb
  • firebird_25_superserver_32bit_4gb.conf 32 bit,
  • firebird_25_superserver_64bit_4gb.conf 64 bit

SuperClassic. This is the recommended architecture for Firebird 2.5. Choose it if you have stable applications (without “Abnormal termination” messages in firebird.log).

• Firebird 2.5 SuperClassic configuration file for server with RAM 8-12Gb, up to 150 connections totally:
  • firebird_25_superclassic_64bit_8gb.conf (64bit only)
• Firebird 2.5 SuperClassic configuration file for server with RAM 16-32Gb, up to 300 connections totally:
  • firebird_25_superclassic_64bit_16gb.conf (64bit only)

Classic. If you have applications with stability problem, or you are using 32bit UDF, choose Classic.

• Firebird 2.5 Classic configuration file for server with RAM8-12Gb, up to 150 connections totally:
  • firebird_25_classic_32bit_8gb.conf 32 bit,
  • firebird_25_classic_64bit_8gb.conf 64.bit
• Firebird 2.5 Classic configuration file for server with RAM16-32Gb, up to 300 connections totally:
  • firebird_25_classic_32bit_16gb.conf 32 bit,
  • firebird_25_classic_64bit_16gb.conf 64.bit

How to proceed
Download configuration files for your Firebird version, copy it to Firebird folder, rename to firebird.conf and restart Firebird (all active users should be disconnected before Firebird restart).
If you intend to change the architecture of Firebird (from SuperServer to SuperClassic, for example), please read the appropriate documentation first.
For all architectures – make sure you don’t override page buffers value in the header page of your database!
To ensure it, run gstat -h databasename and check that Page Buffers is 0. If it is set to other value, set it to 0 with command gfix -buff 0
Important!

• Always rename and keep a copy of your original firebird.conf and, for Firebird 3.0, databases.conf!
• For Firebird 3.0, always check databases.conf! There should be the values you explicitly set. Please make sure you understand why do you set them.
• Remember: settings from firebird.conf are applied to ALL active database on the server as default values, databases.conf (in 3.0) can override firebird.conf.
• Don’t forget about general OS tuning: see Short performance checklist

If you need an optimized configuration file for your specific environment, to get the best possible performance, or if you still have performance issues after applying config from this collection, please contact us to get tailored optimization support.

Optimized configuration files for discontinued versions of Firebird: 1.5, 2.0, 2.1
For discontinued versions of Firebird, we also provide update configurations files, but we really recommend to migrate to the modern Firebird version.

Firebird version	Description	Link
Firebird 1.5	SuperServer 32-bit	firebird_15_superserver.conf
Classic 32-bit	firebird_15_classic.conf
Firebird 2.0	SuperServer 32-bit	firebird_20_superserver.conf
Classic 32-bit	firebird_20_classic.conf
Firebird 2.1	SuperServer 32-bit	firebird_21_superserver_32bit.conf
SuperServer 64-bit	firebird_21_superserver_64bit.conf
Classic 32-bit	firebird_21_classic_32bit.conf
Classic 64-bit	firebird_21_classic_64bit.conf

[/SHOWTOGROUPS]

 

[Volnar]

"Thanks for sharing these Firebird SQL optimized config files. I've been using the old ones for our dev server and it's been running smooth so far. Can you confirm if these new configs are compatible with the latest Firebird 3.x versions?"

 

[zveju6]

"Just downloaded the new config files for Firebird SQL v3.x, anyone else notice a huge boost in performance? The 64bit version seemed to handle concurrent connections way better. Definitely worth the update if you're still on v2.5"

 

[igornigger]

"just upgraded to Firebird 3.0 and I gotta say, the new config files are a breeze to work with. Anyone have any tips on tweaking the 'Monitoring' section for better performance? Been seeing some lag on my app with a large userbase"

 

[ольга222]

"Hey guys, just wondering if anyone's managed to get these optimized config files running smoothly with v3.x? I've been experiencing some issues with memory usage and would love some feedback. Has anyone else had success with these configs?"

 

[_жэка_]

"Just took a look at the new config files, they seem to have optimized the memory allocation for bigger datasets. Was wondering if anyone has noticed any performance boosts with the v3.x versions? Anyone else experiencing issues with the 64bits config?"

 

[ebayaraa]

"Hey guys, just a heads up that the v3.x configs I've been testing seem to be causing some minor lag on my 32-bit setup. Has anyone else noticed this? Maybe we can swap tips on optimizing for 32-bit?"