topic Re: Performance Issue / Bug ? Querying tasks for process variable values for single variable results in lots of joins in Alfresco Archive

Performance Issue / Bug ? Querying tasks for process variable values for single variable results in lots of joins

shailendra1 — Fri, 16 May 2014 17:18:48 GMT

Hi All,I am using TaskQuery to find tasks which belong to processes having certain set of possible process variable values for a single variableFor e.g.,TaskQuery query = taskService.createTaskQuery();query.processVariableValueEquals("a1", "value1");query.processVariableValueEquals("a1", "value2");q

Re: Performance Issue / Bug ? Querying tasks for process variable values for single variable results in lots of joins

shailendra1 — Mon, 19 May 2014 07:33:26 GMT

Hi All,

Any comments please ? This issue is very important for us !

Re: Performance Issue / Bug ? Querying tasks for process variable values for single variable results in lots of joins

martin_grofcik — Tue, 20 May 2014 06:38:26 GMT

Hi Shailendra.

In case that you can create your own query (more efficient one), you can use native query support.
http://www.activiti.org/userguide/#queryAPI

Regards
Martin

Re: Performance Issue / Bug ? Querying tasks for process variable values for single variable results in lots of joins

shailendra1 — Wed, 21 May 2014 09:36:04 GMT

Thanks Martin. As of now I will be using native query support.