[wp-trac] [WordPress Trac] #32770: sql with unnecessary * in comment.php

[WordPress Trac]

#32770: sql with unnecessary * in comment.php
---------------------------+------------------------------
 Reporter:  mesaquesoares  |       Owner:
     Type:  enhancement    |      Status:  new
 Priority:  normal         |   Milestone:  Awaiting Review
Component:  General        |     Version:  4.2.2
 Severity:  normal         |  Resolution:
 Keywords:                 |     Focuses:  performance
---------------------------+------------------------------

Comment (by mesaquesoares):

 Replying to [comment:1 miqrogroove]:
 > `COUNT(*)` is faster.  Why would we remove it?
 >
 > -1
 asterisks have a great cost to sql  because he demands a new discover of
 all columns in the table and this make indexing very poorly.

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