Increasing Firebird Performance

Increasing Firebird Performance

Below are links to two articles relating to potentially increasing Firebird Performance

https://ib-aid.com/en/articles/how-to-make-firebird-work-20-faster-at-windows-server-2016-in-less-than-1-minute/


https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/


You may also consider the following:

  • Review the Current Database Sweep Interval setting. refer this article for more information
  • Monitor CPU loading and consider reconfiguring Firebird to utilise a specific CPU. The option of selecting CPU for Firebird  to utilise is only given when installing Firebird,  so you may need to uninstall and re-install with this new configuration
  • By default Firebird is installed in 'Super Server' mode. Consider reconfiguring Firebird into a 'Super Classic Server' mode. This will run a separate Firebird thread for each Ostendo connection. The option of selecting the Super Classic Mode is only given when installing Firebird,  so you may need to uninstall and re-install with this new configuration
  • Ensure Firebird is installed on the same drive as the Ostendo database as sometimes this can make a difference.
  • There are some great resources also available from IB Surgeon who are performance and tuning specialists in Firebird. They have put together a number of pre-tuned Firebird.conf configuration files that have been tailored for Firebird 2.5 Super Server,(default Ostendo install) and Super Classic environments. The relevant files can be downloaded from this website  https://ib-aid.com/en/optimized-firebird-configuration/ and amended for Ostendo use. NB: The “RemoteAuxPort = 4380” setting requires uncommenting from these files as Ostendo uses this parameter. Before implementing this ensure you read the “How to Proceed” section of the above link.
  • Set energy-saving plan to high-performance (+20% on Windows Server 2016+)
  • Set Write-Caching Policy for drives to Enable Write-Caching
  • In the case of RAID, check that the modern driver is installed, and RAID is configured properly.

There is no guarantee, these suggestions will improve performance as each Server environment and configuration is different, however you should consider and try these suggestions.