Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Optimise database (delete revision posts)

+2 votes
103 views
asked Apr 9, 2017 in Plugins by Badan

Hi Guys,

Is there a plugin or script that i can use to remove all revision posts from my database? My website is getting larger and I want to reduce server load and the response time by deleting unnecessary lines from the database. I am looking for a solution that is similar to what this wordpress plugin does? Do you have any ideas? Thank you in advance!

1 Answer

+2 votes
answered Apr 9, 2017 by Scott
The "revisions" are from a plugin themselves (my Edit History plugin). You can delete revisions manually, but I'll look at adding a way to delete multiple revisions. Maybe it would make more sense to delete SOME revisions but not all.

If you want to clear ALL revisions the easiest method currently is to truncate the qa_edit_history table e.g. with phpMyAdmin.

I don't think clearing the table will make a huge difference to speed, as when viewing questions it only does a simple check if there are revisions (it doesn't load all the revisions). But you could set the visibility in plugin options to a higher user level like Moderators. That way for most users, viewing questions will not touch the revisions table at all.
...