The web reports (web interface), especially the search page, are getting increasingly slower as our database grows. Many queries time out. How can I improve the speed?

Article ID: 6
Category: Web Reports
Applies to: All
Updated: 2019-09-10

If you use the built-in (Postgres) database, you may need to optimize it: https://www.eventsentry.com/kb/232
If you use Microsoft SQL as your database, you may need to optimize it: https://www.eventsentry.com/kb/35
If the recommended optimizations do not help, please contact our support department for more in-depth assistance.

If you have an EventSentry version older than 2.50, please upgrade/migrate to version 2.50 or newer since slowness was addressed with a redesigned database layout. Existing data from EventSentry 2.50 can be migrated with the "Database Migration Wizard". Please refer to the following article for information about upgrading from any particular version of EventSentry to a different version of EventSentry: https://www.eventsentry.com/kb/312