WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #21760, comment 101


Ignore:
Timestamp:
09/28/2016 08:25:15 PM (4 years ago)
Author:
johnjamesjacoby
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #21760, comment 101

    initial v1  
    77
    88* `wp_terms.name` is indexed, so the additional `ORDER BY t.name` bit will not negatively impact performance, even though it's not necessary with a `LIMIT 1`
    9 * MySQL/MariaDB internally optimizes `tt.taxonomy IN ('category')` as `tt.taxonomy = 'category'`, so this change will not negatively impact performance either
     9* MySQL/MariaDB internally optimizes `tt.taxonomy IN ('category')` as `tt.taxonomy = 'category'`, so this change will not negatively impact performance either (same with `t.name IN ('Foo')`).