[wp-trac] [WordPress Trac] #19901: Speeding up Dashboard and Comment moderation SQL load

[WordPress Trac]

#19901: Speeding up Dashboard and Comment moderation SQL load
-------------------------------------------------+-------------------------
 Reporter:  FolioVision                          |       Owner:
     Type:  enhancement                          |  markjaquith
 Priority:  normal                               |      Status:  accepted
Component:  Comments                             |   Milestone:  Future
 Severity:  major                                |  Release
 Keywords:  needs-testing dev-feedback needs-    |     Version:  3.3
  refresh                                        |  Resolution:
                                                 |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by jb510):

 Just another data point (wp_comments w/ 280,000 rows)
 The existing single query took 0.14s
 The multiple queries with unions took 0.09s

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