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!
CPT registration is coming to ACF! We demoed the new feature during the most recent session of ACF Chat Fridays. Check out the summary for the details. https://t.co/k2KQ3WWBAz— Advanced Custom Fields (@wp_acf) March 7, 2023
© 2023 Advanced Custom Fields.