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 over the standard 'Super Server' configuration.
It should also be noted that ideally Firebird should be configured to run over all processors on the server, unless a specific processor is continually under load from other applications.
If Firebird was originally installed on a server with the default options (ie: Super Server), you can uninstall it and re-install it as Super Classic, first ensuring Firebird has been stopped. Before proceeding to re-install Firebird, ensure you have Firebird 2.5.8.27089
Firebird V2.5.8.27089 is available directly from the following link: http://www.ostendo.info/downloads/firebird/firebird25.exe
Refer attached document screen shots for installing and configuring Firebird 2.5.8 Super Classic
Related Articles
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/ ...
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 ...
Ostendo running slowly
Some of the most common factors that could influence speed are: 1) Firebird database needs to be backed up & restored (effectively fixes indexing or data issues) 2) The server is not optimised as a database server (i.e. the disk configuration is ...
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 ...
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 ...