SLA Assessments page is slow to load

Description

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.

Environment

None

Status

Assignee

Greg Hart

Reporter

Greg Hart

Labels

None

Reviewer

None

Story point estimate

None

Affects versions

0.9.1
0.10.0

Priority

Medium
Configure