WordPress.org

Make WordPress Core

Changes between Version 9 and Version 10 of Ticket #19738, comment 7


Ignore:
Timestamp:
10/25/2014 07:07:07 PM (7 years ago)
Author:
Will Brownsberger
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #19738, comment 7

    v9 v10  
    44(2) I found that WP_Query meta casts the longtext metavalues as char like so: CAST(wp_postmeta.meta_value AS CHAR).  Apparently, this prevents the MYSQL optimizer from recognizing the opportunity to use the added index.  If the CAST wrapper is removed, the queries use the index and improve dramatically. 
    55
    6 I have a set of queries against a large set of meta_values and have enhanded the filter suggested above by adding the line below:. I add the filter just before the big queries and then remove so as not to interfere with other queries:
     6I have a set of queries against a large set of meta_values and have enhanced the filter suggested above by adding the line below:. I add the filter just before the big queries and then remove so as not to interfere with other queries:
    77
    88