[wp-trac] [WordPress Trac] #48514: Performance issue in COUNT query pluggable.php

[WordPress Trac]

#48514: Performance issue in COUNT query pluggable.php
-------------------------+-----------------------------
 Reporter:  sgoen        |       Owner:  SergeyBiryukov
     Type:  enhancement  |      Status:  reviewing
 Priority:  normal       |   Milestone:  5.4
Component:  Comments     |     Version:  5.3
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:  performance
-------------------------+-----------------------------

Comment (by SergeyBiryukov):

 Hi there, welcome to WordPress Trac! Thanks for the ticket.

 I was able to reproduce these results with 730000+ comments created via
 `wp comment generate` with WP-CLI.

 In my case, the results were 6.3706 seconds for `count(comment_ID)` vs.
 0.4937 seconds for `count(*)`, which is still quite a noticeable
 improvement.

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