Improving Performance of Opening Lists

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 perform Filtering and Sorting, Ostendo needs to read all available records first. This could run into thousands of records.

In order to improve performance in this area, you should consider using the 'Dynamic Archive Days for Closed and Updated Orders, Invoices & Payments'. This setting can be found in File->System Settings->Environmental Settings (tab). The number you enter here will represent the number of days back from 'Today' to display Closed Orders,  Updated or Fully Paid transactions in the opening Grids. eg: Job Orders, Sales Order, Batch Invoicing, Payments etc..

By reducing the number of transactions based upon this setting, will potential decrease the amount of time, the Grid takes to display the data.

eg: If you only wish to display data going back no more than 3 years, then make this setting 1095 (ie: 365 * 3)

NB: The archived data is NOT removed from the database and is still available for reporting and analysis, however it will not be available to the List Grids. Remember you can always temporarily reset this setting if you need to display the required data at some point.

    • Related Articles

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

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

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