topic Why RuntimeService.deleteProcessInstance() do one by one db call for variables select and deletes? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/why-runtimeservice-deleteprocessinstance-do-one-by-one-db-call/m-p/213213#M166343 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I recently upgraded Activiti to 5.19 and enabled bulkInsertEnabled in processEngineConfiguration. </SPAN><BR /><SPAN>I really like this feature and thanks for providing which really improved performance of my app. </SPAN><BR /><SPAN>I am using RuntimeService.deleteProcessInstance() to delete a processInstance. I got few queries and putting here to clear.</SPAN><BR /><SPAN>As part of delete process instance </SPAN><BR /><SPAN>1) collecting ACT_RU_VARIABLE s one by one using select query by ID_ for process instance. Why activiti is not collecting all at once(using processInstanceId or executionId) at this step?</SPAN><BR /><SPAN>2) its deleting ACT_RU_VARIABLE one by one instead of bulk delete(using processInstanceId or executionId). Is there a way to delete all in one shot to minimise db calls?</SPAN></BODY></HTML> Wed, 25 Nov 2015 16:41:45 GMT swamy2156 2015-11-25T16:41:45Z Why RuntimeService.deleteProcessInstance() do one by one db call for variables select and deletes? https://connect.hyland.com/t5/alfresco-archive/why-runtimeservice-deleteprocessinstance-do-one-by-one-db-call/m-p/213213#M166343 Hi,I recently upgraded Activiti to 5.19 and enabled bulkInsertEnabled in processEngineConfiguration. I really like this feature and thanks for providing which really improved performance of my app. I am using RuntimeService.deleteProcessInstance() to delete a processInstance. I got few queries and p Wed, 25 Nov 2015 16:41:45 GMT https://connect.hyland.com/t5/alfresco-archive/why-runtimeservice-deleteprocessinstance-do-one-by-one-db-call/m-p/213213#M166343 swamy2156 2015-11-25T16:41:45Z Re: Why RuntimeService.deleteProcessInstance() do one by one db call for variables select and deletes? https://connect.hyland.com/t5/alfresco-archive/why-runtimeservice-deleteprocessinstance-do-one-by-one-db-call/m-p/213214#M166344 <HTML><HEAD></HEAD><BODY><SPAN>I think that's indeed an area where we can improve the number of SQL statements executed.</SPAN><BR /><SPAN>Can you create a JIRA issue?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 25 Nov 2015 18:10:23 GMT https://connect.hyland.com/t5/alfresco-archive/why-runtimeservice-deleteprocessinstance-do-one-by-one-db-call/m-p/213214#M166344 trademak 2015-11-25T18:10:23Z