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

      Overview: Garbage Collection: This is the ongoing cleaning of the database and is performed in the background around the clock. This constantly reorganises the memory space used by the database. If you don't clean up the database performance will ...

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

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

    • Manually Running a Database Sweep

      The default database sweep value is 20000. If this value has been amended to Zero, it will be necessary to empty out accumulated 'garbage'. This can be achieved by either performing a Firebird Validate / Backup and Restore of the database, or ...

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