topic Re: 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/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 jbarrez 2016-01-26T09:44:57Z 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