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.



    • Related Articles

    • Firebird Restart to improve performance and remove External Users

      Firebird Stop / Start process Large Ostendo sites running 20+ users should stop and re-start Firebird on a regular basis to ensure performance is maintained. The major issue to automating this process in the past has been the worry that users may ...

    • Database Sweep Interval Setting To Improve Performance

      Amending the Database Sweep Interval Setting Overview: On some large databases, performance issues maybe experienced due to the database Sweep Interval setting being set at a higher level than need be. By default the Sweep Interval setting is set to ...

    • Data Volumes and Impact on Performance

      Data Volumes This article explains how data volumes can influence performance and user experience. Apart from technical Firebird Database settings, Configuration settings within Ostendo can also affect performance. As sites run Ostendo and Freeway ...

    • Installing Firebird 2.5.8.27089 in a multi user environment

      It is suggested that for multi user (Client Server or Terminal Server environments) that Firebird be can installed with the 'Classic -> Super Classic' configuration. It has been demonstrated that in 'some' environments this can improve performance ...

    • Performance Speed Test

      Sometimes it can be useful to conduct a speed test in order to benchmark read / write speed in a database. This is useful when attempting to diagnose a performance problem on a specific database within different environments. By running the speed ...