SLA Assessments page is slow to load
When there are lots of assessments, the SLA assessments page is slow to load.
1. There is an issue with the MySQL query optimizer where it changes the join order. This causes the query to run slower than expected. Forcing MySQL to use the intended join order would resolve the issue.
2. Hibernate is handling the paging of SLA assessments in memory. That means if there are a million assessments, all will be loaded in memory even if only 100 are needed.