WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #31072, comment 3


Ignore:
Timestamp:
07/29/2016 02:44:13 PM (4 years ago)
Author:
rodrigosprimo
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #31072, comment 3

    initial v1  
    1616}}}
    1717
    18 This query runs for every page that displays the admin top bar and, in one of my sites which has about 70k comments, it takes +5 seconds. Adding the index below makes the query run in 1.7 seconds, which is still slow but much better.
     18This query runs for every page that displays the admin top bar and, in one of my sites which has about 2.5 million comments (most of them are of custom WooCommerce comment type called 'order_note'), it takes +5 seconds. Adding the index below makes the query run in 0.3 seconds, which is still slow but much better.
    1919
    2020{{{#!sql