topic ProcessInstanceComments for list of tasks in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203632#M156762 <HTML><HEAD></HEAD><BODY><SPAN>I have a list of about 300 tasks that I display in a table. For each task a user can add comments (which are added to the process on the backend). When I retrieve the list of tasks to display, before rendering this list I iterate it and retrieve comments by using:</SPAN><BR /><BR /><SPAN>List&lt;Comment&gt; comments = taskService.getProcessInstanceComments(task.getProcessInstanceId(), "comment");</SPAN><BR /><BR /><SPAN>Then I display the number of comments for each row, so users know if there is a comment for a specific process. The problem is that the ACT_HI_COMMENT table now has over 350,000 rows and it keeps growing, so the comment retrieval for a list of 300 tasks takes close to a minute. </SPAN><BR /><BR /><SPAN>Is there a better way to accomplish this?</SPAN></BODY></HTML> Thu, 29 Oct 2015 20:44:13 GMT ivan_activiti 2015-10-29T20:44:13Z ProcessInstanceComments for list of tasks https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203632#M156762 I have a list of about 300 tasks that I display in a table. For each task a user can add comments (which are added to the process on the backend). When I retrieve the list of tasks to display, before rendering this list I iterate it and retrieve comments by using:List&lt;Comment&gt; comments = taskS Thu, 29 Oct 2015 20:44:13 GMT https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203632#M156762 ivan_activiti 2015-10-29T20:44:13Z Re: ProcessInstanceComments for list of tasks https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203633#M156763 <HTML><HEAD></HEAD><BODY><SPAN>I ended up taking a CustomSqlExecution direction. I left joined the ACT_HI_COMMENT table in my custom mapper select statement and it seems to work much faster now.</SPAN></BODY></HTML> Fri, 30 Oct 2015 17:55:19 GMT https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203633#M156763 ivan_activiti 2015-10-30T17:55:19Z Re: ProcessInstanceComments for list of tasks https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203634#M156764 <HTML><HEAD></HEAD><BODY><SPAN>Hi Ivan,</SPAN><BR /><BR /><SPAN>Yes you can optimize the query. Another thing is that you have to archive history (History will keep growing….)</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Tue, 03 Nov 2015 08:59:19 GMT https://connect.hyland.com/t5/alfresco-archive/processinstancecomments-for-list-of-tasks/m-p/203634#M156764 martin_grofcik 2015-11-03T08:59:19Z