topic Re: TaskQuery Slow with Variables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190627#M143757 <HTML><HEAD></HEAD><BODY><SPAN>Executing the query separately for process variables and local task variables should improve the performance a lot as well.</SPAN><BR /><SPAN>Could you try to do 2 queries, one with includeProcessVariables() and one with only includeTaskLocalVariables?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 09 Oct 2015 08:03:58 GMT trademak 2015-10-09T08:03:58Z TaskQuery Slow with Variables https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190626#M143756 Hi,We currently have 100,000 records in out act_ru_variable table, and 2,000 in our act_ru_task table.It is taking over 5 minutes to execute the below. ie all tasks that a user is a candidate for.It does not matter how many tasks the user is a candidate for.If I remove the include variables it is ve Fri, 09 Oct 2015 04:57:01 GMT https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190626#M143756 jasonbradfield 2015-10-09T04:57:01Z Re: TaskQuery Slow with Variables https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190627#M143757 <HTML><HEAD></HEAD><BODY><SPAN>Executing the query separately for process variables and local task variables should improve the performance a lot as well.</SPAN><BR /><SPAN>Could you try to do 2 queries, one with includeProcessVariables() and one with only includeTaskLocalVariables?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 09 Oct 2015 08:03:58 GMT https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190627#M143757 trademak 2015-10-09T08:03:58Z Re: TaskQuery Slow with Variables https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190628#M143758 <HTML><HEAD></HEAD><BODY><SPAN>Thanks, that improved the performance. merging the 2 results meant I had to cast the Tasks. </SPAN><BR /></BODY></HTML> Mon, 12 Oct 2015 02:24:47 GMT https://connect.hyland.com/t5/alfresco-archive/taskquery-slow-with-variables/m-p/190628#M143758 jasonbradfield 2015-10-12T02:24:47Z