topic Extremely slow TaskQuery execution with logical operators and paging in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/extremely-slow-taskquery-execution-with-logical-operators-and/m-p/235809#M188939 <HTML><HEAD></HEAD><BODY><SPAN>Hello. </SPAN><BR /><BR /><SPAN>We have a 30,000 task activiti-generated DB. We're trying to fix some performance issues when querying to obtain unassigned tasks with a number of different process variables with paging.</SPAN><BR /><BR /><SPAN>So I modified our current TaskQuery method from this (which already includes paging but not iterating over different process variables):</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />protected List&lt;Task&gt; findUnassignedTasks(TASK taskKey, VARIABLE processVariable, int page, int size) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int offset = page * size;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return buildBaseTaskQuery().<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; processVariableValueEquals(processVariable.getKey(), processVariable.getValue()).<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; includeProcessVariables().<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskUnassigned().<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskDefinitionKey(taskKey.getKey()).<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; listPage(offset, size);<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />//&lt;TASK extends TaskKey, VARIABLE extends ProcessVariable&gt; <BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>To this:</SPAN><BR /><PRE class="language-java line-numbers"><CODE><BR />protected List&lt;Task&gt; findUnassignedTasks(TASK taskKey, VARIABLE[] processVariables, int page, int size) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int offset = page * size;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TaskQuery taskQuery = buildBaseTaskQuery().or();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (int i = 0; i &lt; processVariables.length; i++) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskQuery.processVariableValueEquals(processVariables<EM>.getKey(), processVariables<EM>.getValue());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskQuery.endOr();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return taskQuery.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; includeProcessVariables().<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskUnassigned().<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; taskDefinitionKey(taskKey.getKey()).<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; listPage(offset, size);<BR />&nbsp;&nbsp;&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></EM></EM></CODE></PRE><BR /><BR /><SPAN>But this query takes so long that it goes on timeout… What can I do to speed things up? Am I missing something?</SPAN><BR /><BR /><SPAN>I have tried removing the process variable inclusion but we need it in order to obtain the assignee and other information. Is there a way I could request specific process variables?</SPAN><BR /><BR /></BODY></HTML> Mon, 25 Jan 2016 19:38:31 GMT xvelez 2016-01-25T19:38:31Z Extremely slow TaskQuery execution with logical operators and paging https://connect.hyland.com/t5/alfresco-archive/extremely-slow-taskquery-execution-with-logical-operators-and/m-p/235809#M188939 Hello. We have a 30,000 task activiti-generated DB. We're trying to fix some performance issues when querying to obtain unassigned tasks with a number of different process variables with paging.So I modified our current TaskQuery method from this (which already includes paging but not iterating over Mon, 25 Jan 2016 19:38:31 GMT https://connect.hyland.com/t5/alfresco-archive/extremely-slow-taskquery-execution-with-logical-operators-and/m-p/235809#M188939 xvelez 2016-01-25T19:38:31Z Re: Extremely slow TaskQuery execution with logical operators and paging https://connect.hyland.com/t5/alfresco-archive/extremely-slow-taskquery-execution-with-logical-operators-and/m-p/235810#M188940 <HTML><HEAD></HEAD><BODY><SPAN>The problem is the includeVariables. That is a very costly join that is happening + some post processing.</SPAN><BR /><SPAN>I think that in this case, it would be better to use a native query that does directly what you want to do.</SPAN></BODY></HTML> Tue, 26 Jan 2016 09:44:57 GMT https://connect.hyland.com/t5/alfresco-archive/extremely-slow-taskquery-execution-with-logical-operators-and/m-p/235810#M188940 jbarrez 2016-01-26T09:44:57Z