I am trying to delete ~40,000 topics from discourse. The method I use is programming a browser macro service Kantu Browser Automation - Chrome Web Store to go to a specific search page in my Discourse site, click on then select all and click on and click on the red delete-topics button.
I play this macro in a loop so it deletes 50 posts at a time, but after a few cycles, the site crashes.
Is there a better method?
Why is deleting posts such a heavy task for the server?