topic Re: Deleting over 1000 nodes in Alfresco Archive

Deleting over 1000 nodes

buje85 — Wed, 25 Nov 2015 12:55:04 GMT

Hi, How are people deleting a large number of nodes from the repository that are stored based on metadata and not all stored under one root folder?For example I have 60,000 files that need removing. If I use the javascript console I can search and find 1000 nodes based on some metadata properties th

Re: Deleting over 1000 nodes

douglascrp — Thu, 26 Nov 2015 18:09:27 GMT

I think this presentation can give you some ideas:
https://summit.alfresco.com/san-francisco/sessions/advanced-repository-administration-javascript

Search for the topic "How to Process Lots of Nodes"

Re: Deleting over 1000 nodes

buje85 — Thu, 03 Dec 2015 11:48:10 GMT

Thanks, that is really useful!

Re: Deleting over 1000 nodes

aowian — Thu, 09 Feb 2017 12:31:10 GMT

Increasing the number of nodes to get from a query can only help you find the nodes.

Plus, processing a lot of nodes in one transaction can kill the Alfresco application by eating up all the resources. Believe me. I tried it.

Also, there is still a 1000 node limit on a writable transaction, unless that can be overridden.

I tried wrapping the transaction as shown in Bindu's Summit presentation and putting that in a loop,

but I ended up getting the same nodes each execution of the loop.

Finally this worked:

From the Javascript Console, choose Script execution parameters,

and for Run like crazy: choose continuously 10s delay.

This allows Alfresco to throttle the processing so as to not overload the server,

and it batches the runs committing each transaction after processing 1000 nodes.

Re: Deleting over 1000 nodes

mevlutozdemir — Thu, 21 Mar 2019 10:53:45 GMT

Hi,

The link in your comment is not working anymore.

Is the link to the script still available? If yes were can I find it (could not find it myself)

Thanks,