Created
December 18, 2015 15:35
-
-
Save yegnold/3815eb50a27cbb1a5853 to your computer and use it in GitHub Desktop.
Quick Pagepost redirect plugin optimisation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// OLD QUERY, 0.525s: | |
$finalSQL = "SELECT * FROM {$wpdb->prefix}postmeta as `m1` WHERE {$whereSQL} m1.post_id IN ( SELECT post_id FROM {$wpdb->prefix}postmeta as `m` WHERE 1 = 1 AND m.meta_key ='_pprredirect_active' AND m.meta_value = '1');"; | |
// NEW query, 0.0007s: | |
$finalSQL = "SELECT m1.* FROM {$wpdb->prefix}postmeta as `m1` INNER JOIN {$wpdb->prefix}postmeta as `m` WHERE 1 = 1 AND m.meta_key ='_pprredirect_active' AND m.meta_value = '1' AND m.post_id = m1.post_id"; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment