topic listPage doesn't improve query time for createHistoricProcessInstanceQuery when using includeProcessVariables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/listpage-doesn-t-improve-query-time-for/m-p/209176#M162306 <HTML><HEAD></HEAD><BODY><SPAN>includeProcessVariables() in HistoricProcessInstanceQuery increases query time very very seriously. </SPAN><BR /><BR /><SPAN>Query times are:</SPAN><BR /><BR /><SPAN>Without includeProcessVariables() : &amp;lt 1s</SPAN><BR /><SPAN>With includeProcessVariables() : 20-30s</SPAN><BR /><BR /><SPAN>so I decided to use .listPage( first, pageSize ) but with values like ( 0, 10 ) it is still the same 20-30s</SPAN><BR /><BR /><SPAN>interesting that when using variableValueLike( "searchValue%", searchValue ) that returns 10-20 items it queries quick: 1-2s</SPAN><BR /><BR /><SPAN>I understand that includeProcessVariables() increases query time but </SPAN><STRONG>why listPage( first, pageSize ) doesn't improve?</STRONG><BR /><BR /><SPAN>Below is my query:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />List&lt;HistoricProcessInstance&gt; result = historyService.createHistoricProcessInstanceQuery()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.processDefinitionKey( "Process1" )<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.finished()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.variableValueLike( "searchString", searchValue )<BR />&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;.orderByProcessInstanceStartTime()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.desc()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.listPage( first, pageSize );<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sun, 30 Aug 2015 07:53:08 GMT p4w3l 2015-08-30T07:53:08Z listPage doesn't improve query time for createHistoricProcessInstanceQuery when using includeProcessVariables https://connect.hyland.com/t5/alfresco-archive/listpage-doesn-t-improve-query-time-for/m-p/209176#M162306 includeProcessVariables() in HistoricProcessInstanceQuery increases query time very very seriously. Query times are:Without includeProcessVariables() : &amp;lt 1sWith includeProcessVariables() : 20-30sso I decided to use .listPage( first, pageSize ) but with values like ( 0, 10 ) it is still the sam Sun, 30 Aug 2015 07:53:08 GMT https://connect.hyland.com/t5/alfresco-archive/listpage-doesn-t-improve-query-time-for/m-p/209176#M162306 p4w3l 2015-08-30T07:53:08Z Re: listPage doesn't improve query time for createHistoricProcessInstanceQuery when using includeProcessVariables https://connect.hyland.com/t5/alfresco-archive/listpage-doesn-t-improve-query-time-for/m-p/209177#M162307 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>if you'll have a look into the code in the class: HistoricProcessInstanceEntityManager.java&nbsp; at method: findHistoricProcessInstancesAndVariablesByQueryCriteria</SPAN><BR /><BR /><SPAN>you'll see this comment: </SPAN><BR /><SPAN>&lt;code&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; // paging doesn't work for combining process instances and variables due to an outer join, so doing it in-memory</SPAN><BR /><SPAN>&lt;/code&gt;</SPAN><BR /><BR /><SPAN>Sorry for the inconvenient but this is what was possible to be done at that moment.</SPAN></BODY></HTML> Sun, 30 Aug 2015 21:38:53 GMT https://connect.hyland.com/t5/alfresco-archive/listpage-doesn-t-improve-query-time-for/m-p/209177#M162307 vasile_dirla 2015-08-30T21:38:53Z