Skip to content

Instantly share code, notes, and snippets.

@yegnold
Created December 18, 2015 15:35
Show Gist options
  • Save yegnold/3815eb50a27cbb1a5853 to your computer and use it in GitHub Desktop.
Save yegnold/3815eb50a27cbb1a5853 to your computer and use it in GitHub Desktop.
Quick Pagepost redirect plugin optimisation
<?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