[ODE-795] Speed up listAllProcesses

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.3
• Fix Version/s: 1.3.4
• Component/s: BPEL Runtime
• Assignee: Rafal Rusin
• Reporter: Rafal Rusin
• Created: 30/Mar/10 16:37
• Updated: 13/Jan/11 15:59
• Resolved: 12/Jul/10 13:24

Description

listAllProcesses in ProcessAndInstanceManagementImpl.java does a lot of queries to database in order to fetch instance summary. This causes transaction timeout. on ODE load.

Disabling instance summary is a workaround:

diff --git a/bpel-runtime/src/main/java/org/apache/ode/bpel/engine/ProcessAndInstanceManagementImpl.java b/bpel-runtime/src/main/java/org/apache/ode/bpel/engine/ProcessAndInstanceManagementImpl.java
index 47ada7a..0317864 100644
— a/bpel-runtime/src/main/java/org/apache/ode/bpel/engine/ProcessAndInstanceManagementImpl.java
+++ b/bpel-runtime/src/main/java/org/apache/ode/bpel/engine/ProcessAndInstanceManagementImpl.java
@@ -805,6 +805,7 @@ public class ProcessAndInstanceManagementImpl implements InstanceManagement, Pro
depinfo.setDocument(pconf.getBpelDocument());
depinfo.setDeployDate(toCalendar(pconf.getDeployDate()));
depinfo.setDeployer(pconf.getDeployer());
+ /*
if (custom.includeInstanceSummary())

{ TInstanceSummary isum = info.addNewInstanceSummary(); genInstanceSummaryEntry(conn, isum.addNewInstances(), TInstanceStatus.ACTIVE, pconf); @@ -814,7 +815,7 @@ public class ProcessAndInstanceManagementImpl implements InstanceManagement, Pro genInstanceSummaryEntry(conn, isum.addNewInstances(), TInstanceStatus.SUSPENDED, pconf); genInstanceSummaryEntry(conn, isum.addNewInstances(), TInstanceStatus.TERMINATED, pconf); getInstanceSummaryActivityFailure(conn, isum, pconf); - }

+ }*/

if (custom.includeDocumentLists()) {
TProcessInfo.Documents docinfo = info.addNewDocuments();