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?
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: