[
https://issues.apache.org/jira/browse/ODE-1049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15181613#comment-15181613
]
Hudson commented on ODE-1049:
-----------------------------
SUCCESS: Integrated in ODE-1.x #532 (See
[https://builds.apache.org/job/ODE-1.x/532/])
ODE-1049: Optimised findRoute and dequeueMessage queries to use pre (sathwik:
[https://github.com/apache/ode/commit/58b1a735ddb58c381e7ef356e8c70f3f6f71aa93])
* dao-jpa/src/main/java/org/apache/ode/dao/jpa/CorrelatorDAOImpl.java
*
bpel-runtime/src/main/java/org/apache/ode/bpel/engine/BpelRuntimeContextImpl.java
* bpel-runtime/src/main/java/org/apache/ode/bpel/memdao/CorrelatorDaoImpl.java
* dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/CorrelatorDaoImpl.java
* bpel-dao/src/main/java/org/apache/ode/bpel/dao/CorrelatorDAO.java
> 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)
