Site slows when mass approving reviews
-
If you go down a list of site reviews and approve them one after the other my site slows to a crawl. Not sure if it is due to cache clearing during each event (probably varnish) or something else holding up the process?
-
Each time you are approving a review, you are actually changing the WordPress status of the review post_type from “pending” to “publish”. Internally in WordPress, this is done the same way as you would change the status of a post or page. The only difference is that Site Reviews uses a javascript AJAX request to change the review status without having to refresh the page.
If you have many reviews that need changing status, I suggest you use the WordPress “Bulk Edit” tool instead of doing them one-by-one.
By the way, since changing the review status to “Approved” updates the “post_status” value in the database, if your site is configured to rebuild the cache after every database change then approving them one-by-one may force your cache to rebuild each time (making it appear to take longer than it should).
If you use the “Bulk Edit” tool (by selecting multiple review checkboxes and selecting the “Edit” button from the “Bulk Actions” dropdown), then it should update all reviews using a single database query (instead of using a database query for each review). This way, your cache will only need to be rebuilt once.
- The topic ‘Site slows when mass approving reviews’ is closed to new replies.
