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
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 ...
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 ...
Improving Performance of Opening Lists
As a database gets larger, the opening List grids can take longer to load, when 'Include Closed' Orders, 'Include Updated Status' or 'Include Fully Paid' is turned on along with Filtering and Sorting from the Grid options. This is because in order to ...