ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ODE-1049) Query optimization to findRoute and dequeueMessage queries - MATCHER job
Date Sat, 05 Mar 2016 07:36:40 GMT

    [ 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)

Mime
View raw message