WPIntell

Source evidence

Does the job!

Optimize Database after Deleting Revisions · review · 2024-09-02T07:45:00+00:00

praisesentiment
highseverity
0.73relevance
0replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

4 / 31 rows with source links

12.9% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

27 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

review · 5 stars
copytrans unresolved
I have used this plugin on 5 different multi-site wordpress and have achieved awesome results. Here’s the best one: 13779 revisions deleted database size reduced from 297MB to 65MB = 22% of original size!! this lead to an 11% speed gain (server side execution time to generate the page) we had such good results, because we had no limit on the number of revisions per post a few years back. wordpress does not automatically clean the revisions. The revisions for a post, only get cleaned up when you actually work on a post. In our case we had revisions from 2015 that were still encumbering the database. Those are the settings I used: Delete revisions of: POST, PAGE, USER_REQUEST, WP_BLOCK, WP_TEMPLATE, WP_TEMPLATE_PART, WP_GLOBAL_STYLES, WP_NAVIGATION, WP_FONT_FAMILY, WP_FONT_FACE Delete revisions older than: 720 days Maximum number of - most recent - revisions to keep per post / page: 25 Delete trashed items: YES Delete spammed items: YES Delete unused tags: YES Delete transients: NO Delete pingbacks and trackbacks: YES Clear oEmbed cache: NO Keep a log: YES Optimize InnoDB tables: YES Number of excluded tables: 0 I’ve reviewed the plugin’s source code and tested it extensively and found out a few issues in the source code that I have shared with the maintainers. Overall, I think this plugin is safe to use, provided you backup your database before and that you fully understand what you’re doing.

Comments

0 shown

No comments were stored for this source.