topic Re: listPage doesn't improve query time for createHistoricProcessInstanceQuery when using includeProcessVariables in Alfresco Archive

listPage doesn't improve query time for createHistoricProcessInstanceQuery when using includeProcessVariables

p4w3l — Sun, 30 Aug 2015 07:53:08 GMT

includeProcessVariables() in HistoricProcessInstanceQuery increases query time very very seriously. Query times are:Without includeProcessVariables() : &lt 1sWith includeProcessVariables() : 20-30sso I decided to use .listPage( first, pageSize ) but with values like ( 0, 10 ) it is still the sam

Re: listPage doesn't improve query time for createHistoricProcessInstanceQuery when using includeProcessVariables

vasile_dirla — Sun, 30 Aug 2015 21:38:53 GMT

Hi,
if you'll have a look into the code in the class: HistoricProcessInstanceEntityManager.java at method: findHistoricProcessInstancesAndVariablesByQueryCriteria

you'll see this comment:
<code>
// paging doesn't work for combining process instances and variables due to an outer join, so doing it in-memory
</code>

Sorry for the inconvenient but this is what was possible to be done at that moment.