[
https://issues.apache.org/jira/browse/ODE-444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661512#action_12661512
]
Piotr Jagielski commented on ODE-444:
-------------------------------------
Is this patch going to be applied on trunk? I searched the code and found that
it isn't and comments say that listInstances will be deprecated since ODE 1.3
> Improve performance of InstanceManagement (1.x branch)
> ------------------------------------------------------
>
> Key: ODE-444
> URL: https://issues.apache.org/jira/browse/ODE-444
> Project: ODE
> Issue Type: Task
> Components: Management Console
> Affects Versions: 1.2
> Reporter: Alex Boisvert
> Assignee: Alex Boisvert
> Fix For: 1.3
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
