WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 9 of Ticket #15004


Ignore:
Timestamp:
07/10/2012 02:03:15 PM (12 years ago)
Author:
nacin
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #15004

    • Property Keywords has-patch commit added
    • Property Milestone changed from Awaiting Review to 3.5
    • Property Summary changed from Missing index on wp_signups to Missing index on signups table

  • Ticket #15004 – Description

    initial v9  
    1 wp-includes/ms-functions.php:590:       $signup = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->signups WHERE user_email = %s", $user_email) );
    2 wp-includes/ms-functions.php:595:                       $wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->signups WHERE user_email = %s", $user_email) );
     1{{{
     2wp-includes/ms-functions.php:590:
     3$signup = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->signups WHERE user_email = %s", $user_email) );
     4wp-includes/ms-functions.php:595:
     5$wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->signups WHERE user_email = %s", $user_email) );
     6}}}
    37
    48But there is no index on user_email in the signups table.  Makes these queries perform a full table scan which is slow when you have lots of signups.