[ODE-444] Improve performance of InstanceManagement (1.x branch)

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2
• Fix Version/s: 1.3.2
• Component/s: Management Console
• Assignee: Alex Boisvert
• Reporter: Alex Boisvert
• Created: 02/Dec/08 00:08
• Updated: 24/Apr/09 00:54
• Resolved: 03/Dec/08 00:10

Description

There are some performance issues with the current InstanceManagement.listXXXInstances() operations, notably:

1) listAllInstances() is quite dangerous – it will run into OutOfMemoryException if you have lots of instances
2) listAllInstancesWithLimit() is better but suffers performance-wise because it attempts to load the instance summary data, the events, the scopes and properties of the matching instances. This result is too much database activity for the common case, moreover the current implementation is horrific because it actually performs 4 joins for each instance!

So I'm introducing listInstancesSummary(String filter, String order, int limit) that only loads the instance summary and the properties in only 3 joins (total, not per instance) to address these performance issues and making both listAllInstances() and listAllInstancesWithLimit() use this method under the cover.