woothemes / woocommerce / 8098

23%

master: 53%

push

travis-ci

Cache the result of WC_Comments::wp_count_comments() in a transient

The query to count comments inside WC_Comments::wp_count_comments() is super slow when the site has a significant number of comments (for example, this query takes about 5s to run on WooCommerce.com with 70k comments) and this is a problem specially considering that this method is called on every admin page.

This commit changes WC_Comments::wp_count_comments() to store the comments count in a transient. With this change, the method will run the query to count comments only if the number of comments or their statuses had changed. Before this commit, WC_Comments::wp_count_comments() would run the database query every time a admin page was requested.

26 of 26 new or added lines in 1 file covered. (100.0%)

6538 of 28907 relevant lines covered (22.62%)

6.5 hits per line