You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2017/06/29 06:57:00 UTC
[jira] [Commented] (ODE-1049) Query optimization to findRoute and
dequeueMessage queries - MATCHER job
[ https://issues.apache.org/jira/browse/ODE-1049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16067867#comment-16067867 ]
Hudson commented on ODE-1049:
-----------------------------
SUCCESS: Integrated in Jenkins build ODE-trunk-jdk6 #878 (See [https://builds.apache.org/job/ODE-trunk-jdk6/878/])
ODE-1049: Optimised findRoute and dequeueMessage queries to use pre (sathwik: rev d4c3aa74016936f3b829d9ca6fdd872b261b76eb)
* (edit) dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/CorrelatorDaoImpl.java
* (edit) bpel-runtime/src/main/java/org/apache/ode/bpel/engine/BpelRuntimeContextImpl.java
* (edit) bpel-dao/src/main/java/org/apache/ode/bpel/dao/CorrelatorDAO.java
* (add) ODE-1049.patch
* (edit) dao-jpa/src/main/java/org/apache/ode/dao/jpa/CorrelatorDAOImpl.java
* (edit) bpel-runtime/src/main/java/org/apache/ode/bpel/memdao/CorrelatorDaoImpl.java
Removed ODE-1049.patch committed by mistake (sathwik: rev 80519edff75c8550e2f94a276813d2c0706e5758)
* (delete) ODE-1049.patch
> 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)