Search
Other Better Trash questions
Forum

Delete huge amount of articles

Kovacs Peter's Avatar Kovacs Peter
Hello

There is a J3 site which has >29000 articles, and >20000 of them are trashed.
We plan to remove these trashed articles but it's very slow. I checked 20 articles and deleted with Joomla's core delete button and it took >a minute. I found out this is because the assets table.
Does Better Trash have faster solution for that? Even maybe via CLI?
Peter van Westen's Avatar Peter van Westen ADMIN
No, Better Trash does not influence the speed at which articles are deleted.
Does the time double when you try to delete 40 articles?

You could do this via SQL directly.
First output a list of article ids that you want to remove.
Then delete all those from the content table.
And delete the records from the assets table where the name matches the article ids:
com_content.article.XXX
Please post a rating at the Joomla! Extensions Directory
Kovacs Peter's Avatar Kovacs Peter
"Does the time double when you try to delete 40 articles?" - yes

About the manual delete:
As far as I can see, the delete logic recalculates the lft and rgt values as well. Is it enough to delete by `name`?
Peter van Westen's Avatar Peter van Westen ADMIN
I kn0w that ACL Manager has an assets fixer:
extensions.joomla.org/extension/acl-manager/

So then you could just remove the articles from the content table. Then run the assets fixer.
Please post a rating at the Joomla! Extensions Directory
You can only post on the extension support forum if you have an active subscription and you log in

Buy a Pro subscription