Sathwik Bantwal Premakumar created ODE-1049: -----------------------------------------------
Summary: Query optimization to findRoute and dequeueMessage queries - MATCHER job Key: ODE-1049 URL: https://issues.apache.org/jira/browse/ODE-1049 Project: ODE Issue Type: Improvement Components: BPEL Runtime Reporter: Sathwik Bantwal Premakumar Assignee: Sathwik Bantwal Premakumar Fix For: 1.3.7 During the execution of MATCHER job the CorrelationKeySet used will only contain pre initialised correlation keys. https://github.com/apache/ode/blob/ode-1.3.x/bpel-runtime/src/main/java/org/apache/ode/bpel/runtime/PICK.java#L87 https://github.com/apache/ode/blob/ode-1.3.x/bpel-runtime/src/main/java/org/apache/ode/bpel/runtime/EH_EVENT.java#L120 Hence we can directly use the CorrelationKeySet's canonical value instead of its subsets for both findRoute and dequeueMessage method calls within matcherEvent. This avoids the use of SQL IN clause in the findRoute and dequeueMessage queries and improves the execution time of these queries. -- This message was sent by Atlassian JIRA (v6.3.4#6332)