WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #28160, comment 14


Ignore:
Timestamp:
02/27/2022 06:46:55 PM (3 years ago)
Author:
OllieJones
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #28160, comment 14

    initial v1  
    55Here's something I wrote for a related ticket. https://core.trac.wordpress.org/ticket/33885#comment:86
    66
     7
    78@SergeyBiryukov says they are looking at this indexing opportunity in the performance team. https://github.com/WordPress/performance/issues/132
    89
     10All that being said, this WHERE clause `CAST(wp_usermeta.meta_value AS CHAR) != '0'` could be simpler, slightly faster, and still precisely equivalent, if it said simply `wp_usermeta.meta_value != '0'`.