Dashboard Performance Issue - Event & EventArchive Tables
Hope you are having a good day today.
Some of our clients have the performance issue that the dashboard is quite slow.
Those clients have more than 100 users, and Event & EventArchive tables are growing very large and every time after deleting contents from those two tables, the performance becomes better.
Our team would like to get advice about how to setup automatically truncate those two tables at a regular basis like 15 days or 20 days.
And we also want to know why those two tables will impact our dashboard performance, we have Activity Tab to monitor dashboard usage, push reports and users logins.
Thanks for your assistance.