[jira] [Updated] (ODE-1049) Query optimization to findRoute and dequeueMessage queries - MATCHER job

["Sathwik Bantwal Premakumar (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ODE-1049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sathwik Bantwal Premakumar updated ODE-1049:
--------------------------------------------
    Fix Version/s: 1.4

> 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, 1.4
>
>
> 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.4.14#64029)