Ostendo running slowly

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 designed for a file server - copying large files, rather than high I/O traffic)

3) Anti-virus software is slowing down performance

4) The server is running other processes (such as exchange server etc) which also require a high level of disk access.

5) Refer to the following Knowledgebase Article "Installing Firebird 2.5.8 in a multi user environment"

6) Review the Current Database Sweep Interval setting. refer this article for more information



    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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/ ...

    • 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 ...