[ODE-1049] Query optimization to findRoute and dequeueMessage queries - MATCHER job

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.7, 1.4
• Component/s: BPEL Runtime
• Assignee: Sathwik
• Reporter: Sathwik
• Created: 05/Mar/16 06:27
• Updated: 28/Nov/17 07:56
• Resolved: 08/Jul/16 07:15

Description

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.

Issue Links

• is required by: ODE-1061 List of Bugs to be ported to trunk from 1.3.7