topic Re: Problem with delete big folder in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44752#M18163 <HTML><HEAD></HEAD><BODY><P>You have to realise that a massive operation like that won't ever be fast. You are also not helping things by specifying permanent=false, which means all the deleted&nbsp;documents will actually be copied into archive / trash can, doubling the amount of operations to be performed (each&nbsp;deleted node will require at least 3 SQL delete,1 insert and 1 update statements - maybe more - , and when you allow archiving to take place you effectively require at least another 4 SQL insert statements). Also, since Alfresco supports event-based processing, for every document that is being deleted it will check if there has been any configured event processing (rule / behaviour) and may execute that defined logic. Of course during the whole operation, Alfresco has to collect / hold a lot of runtime data in-memory, which can lead to memory issues if your server has insufficient resources assigned to it.</P><P>It is never a good idea to try and delete (or modify) more than a few hundred elements in a single operation. Your deletion should be implemented as an incremental operation instead of trying to delete the whole folder in one go...</P></BODY></HTML> Wed, 28 Nov 2018 10:03:00 GMT afaust 2018-11-28T10:03:00Z Problem with delete big folder https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44751#M18162 Hi,I'm using Alfresco Enterprise 5.2.3, and I want delete folder with 50.000 - 200.000 documents inside.&nbsp;I tried delete by public rest API:alfresco/api/-default-/public/alfresco/versions/1/nodes/30fa7bab-5c3a-46dc-ac32-51eac80008f6?permanent=falseAnd this is endless query. After few hours in server Wed, 28 Nov 2018 07:57:50 GMT https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44751#M18162 jmal 2018-11-28T07:57:50Z Re: Problem with delete big folder https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44752#M18163 <HTML><HEAD></HEAD><BODY><P>You have to realise that a massive operation like that won't ever be fast. You are also not helping things by specifying permanent=false, which means all the deleted&nbsp;documents will actually be copied into archive / trash can, doubling the amount of operations to be performed (each&nbsp;deleted node will require at least 3 SQL delete,1 insert and 1 update statements - maybe more - , and when you allow archiving to take place you effectively require at least another 4 SQL insert statements). Also, since Alfresco supports event-based processing, for every document that is being deleted it will check if there has been any configured event processing (rule / behaviour) and may execute that defined logic. Of course during the whole operation, Alfresco has to collect / hold a lot of runtime data in-memory, which can lead to memory issues if your server has insufficient resources assigned to it.</P><P>It is never a good idea to try and delete (or modify) more than a few hundred elements in a single operation. Your deletion should be implemented as an incremental operation instead of trying to delete the whole folder in one go...</P></BODY></HTML> Wed, 28 Nov 2018 10:03:00 GMT https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44752#M18163 afaust 2018-11-28T10:03:00Z Re: Problem with delete big folder https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44753#M18164 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can reckon to use the MassiveDelete tool:</P><P></P><P><A class="jivelink10" href="https://github.com/fsforna/MassiveDelete" title="https://github.com/fsforna/MassiveDelete" rel="nofollow noopener noreferrer">https://github.com/fsforna/MassiveDelete</A></P></BODY></HTML> Wed, 05 Dec 2018 15:15:11 GMT https://connect.hyland.com/t5/alfresco-forum/problem-with-delete-big-folder/m-p/44753#M18164 francesco_forna 2018-12-05T15:15:11Z