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