-
Task
-
Resolution: Won't Do
-
Normal
-
None
-
None
-
None
-
False
-
None
-
False
-
-
Issue Description:
Some of the manager database queries in v2 are sub-optimal.
Logs show HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!. The issue can be avoided quite simply by performing two queries. See here for an informed discussion.
Acceptance Criteria:
Database queries/Hibernate pagination is optimised.