[wp-trac] [WordPress Trac] #46243: WordPress Comments Core Query

[WordPress Trac]

#46243: WordPress Comments Core Query
--------------------------+------------------------------
 Reporter:  Uranbold      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Comments      |     Version:  5.0.3
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |     Focuses:
--------------------------+------------------------------
Changes (by swissspidy):

 * keywords:   => dev-feedback


Comment:

 Are you using some sort of object cache on your site? Because the comment
 count would be cached in that case. Plus, with your amount of data you
 really should think about leveraging an external object cache.

 Plus, you can hook into the `wp_count_comments` filter to prevent that SQL
 query from running.

 I don't see how else we could drastically improve that query in a way that
 it's worth doing.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/46243#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform