topic Performance - Bulk deletion of variables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203119#M156249 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I'm looking for a solution to delete variables in a bulk job.</SPAN><BR /><SPAN>Activiti deletes at the end of a process every variable in a single delete Statement.</SPAN><BR /><SPAN>In my case the deletion of 15 variables per process instance takes 17% of the whole db machine time.</SPAN><BR /><BR /><SPAN>If I delete it manual (ProcessEndListener)</SPAN><BR /><SPAN>delete from act_ru_variables where _proc_inst = ?</SPAN><BR /><SPAN>i've got a OptimisticLockException.</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Wed, 25 Jun 2014 18:31:59 GMT samson 2014-06-25T18:31:59Z Performance - Bulk deletion of variables https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203119#M156249 Hello,I'm looking for a solution to delete variables in a bulk job.Activiti deletes at the end of a process every variable in a single delete Statement.In my case the deletion of 15 variables per process instance takes 17% of the whole db machine time.If I delete it manual (ProcessEndListener)delete Wed, 25 Jun 2014 18:31:59 GMT https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203119#M156249 samson 2014-06-25T18:31:59Z Re: Performance - Bulk deletion of variables https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203120#M156250 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>May be you are getting OptimisticLockingException because RemoveExecutionVariablesCmd (Task)&nbsp; tries to delete the variables too.</SPAN><BR /><SPAN>I am not sure.</SPAN><BR /><BR /><SPAN>What I would propose is to change implementation and create pull request.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Thu, 26 Jun 2014 07:13:38 GMT https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203120#M156250 martin_grofcik 2014-06-26T07:13:38Z Re: Performance - Bulk deletion of variables https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203121#M156251 <HTML><HEAD></HEAD><BODY><SPAN>Hi Martin,</SPAN><BR /><BR /><SPAN>you are right, Activiti tries to delete the variable too. That would be fabulous if someone could change the implementation.</SPAN></BODY></HTML> Thu, 26 Jun 2014 07:47:01 GMT https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203121#M156251 samson 2014-06-26T07:47:01Z Re: Performance - Bulk deletion of variables https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203122#M156252 <HTML><HEAD></HEAD><BODY><SPAN>Jira Ticket created: </SPAN><A href="http://jira.codehaus.org/browse/ACT-2037" rel="nofollow noopener noreferrer">http://jira.codehaus.org/browse/ACT-2037</A></BODY></HTML> Fri, 27 Jun 2014 07:44:14 GMT https://connect.hyland.com/t5/alfresco-archive/performance-bulk-deletion-of-variables/m-p/203122#M156252 samson 2014-06-27T07:44:14Z