Incorrect Join leads to 20 second MySQL queries
-
On line 273 of wp-customer-reviews-3.php, you have
INNER JOIN {$wpdb->prefix}postmeta pm3 ON pm3.meta_key = 'wpcr3_enable' AND pm3.meta_value = '1'it should be
INNER JOIN {$wpdb->prefix}postmeta pm3 ON pm3.meta_key = 'wpcr3_enable' AND pm3.meta_value = '1' AND pm3.post_id = p3.idThat error delayed our site launch by a week or two because it was causing 60 second page loads as it was generating a result set of 500,000 records.
- The topic ‘Incorrect Join leads to 20 second MySQL queries’ is closed to new replies.
