Home › Forums › General Issues › Performance issues in the backend (wp-admin) › Reply To: Performance issues in the backend (wp-admin)
I’ve run into issues before with having too many post revisions stored in the database. Cleaning them out helped. You can run this query to see where you’re at.
SELECT COUNT(*) FROM wp_posts WHERE post_type = "revision"
if you have wp cli installed it’s as easy as
/path/to/wordpress/ $ wp db query 'SELECT COUNT(*) FROM wp_posts WHERE post_type = "revision"'
If that number seems high (I can’t really say what high is, depends on how many posts you have) you could make a backup of your db (!), delete all the revisions and see if that speeds things up.
/path/to/wordpress/ $ wb db export /path/to/your/backup/home/mysite.snapshot.sql
/path/to/wordpress/ $ wp db query 'DELETE FROM wp_posts WHERE post_type = "revision"'
There are plugins to make deleting a little more nuanced. Say, delete all but the last 2 revisions or whatever.
If that turns out to be the problem, you can permanently cap the revisions count in your wp-config with this line:
define( 'WP_POST_REVISIONS', 3 );
More info here: http://codex.wordpress.org/Editing_wp-config.php#Specify_the_Number_of_Post_Revisions
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.