If the number of queue events stored in the Enswitch database becomes excessive, performance may suffer. This can be cured by archiving old events.

Archiving queue events locally

If old queue events are still required, they can be archived within the Enswitch database. This improves the performance of the queue events export, but still makes the archived events available if necessary. To do this, change the "Table containing archived queue events" configuration setting to "queue_events_archive", then add an entry similar to the following to /etc/crontab:

39 3 * * * enswitch /opt/enswitch/current/bin/queue_events_archive 90

This archives queue events older than 90 days every night at 3:39am.

Archived queue events are moved from the queue_events to the queue_events_archive table within the Enswitch database. This improves performance by reducing the size of the indexes on the queue_events table, making the searches done by the queue events export faster.

Archived queue events are hidden from all users by default. It is possible to allow some roles to access them by granting the "Read archived data" role permission. This should be done with caution because it reduces the performance gains made by archiving, and should normally be limited to the system owner role.

Archiving queue events remotely

As an alternative to archiving queue events locally as above, events can be moved to a remote database on another machine. THIS IS NOT SUPPORTED, AND NOT RECOMMENDED. IF YOU DO THIS, YOU ARE RESPONSIBLE FOR CONFIGURING AND MANAGING THE REMOTE MACHINE. YOU WILL NEED TO MERGE ANY SCHEMA CHANGES MADE BY FUTURE ENSWITCH UPGRADES. If you're sure you want to do this, the steps are:

1. Contact Enswitch support and let them know you're doing this. They will disown any responsibility for what you're doing.
2. Take a backup of the Enswitch database.
3. If you've archived any queue events locally, move them back to the queue_events table.
4. Create the remote database, with the queue_events table. This table must have exactly the same schema as the Enswitch database. Note that if future versions of Enswitch change these schemas, you must manually change the remote database.
5. Create a database user for the new database, and give them access to the queue_events table.
6. Create "delete/queues/events/archive", "insert/queues/events/archive", and "select/queues/events/archive" handlers in /etc/enswitch/databases.ini.
7. Change the "Table containing archived queue events" configuration setting to "queue_events".
8. Restart the web server.
9. Create a crontab entry, similar to the local archiving above, but for "/opt/enswitch/current/bin/queue_events_archive_remote".
10. Run "/opt/enswitch/current/bin/queue_events_archive_remote <days>" manually.
11. Check that the data in both databases is as you expect.
12. Enable the "Read archived data" permission for any roles that may access archived queue events. This should be done with caution because it reduces the performance gains made by archiving, and should normally be limited to the system owner role.