WordPress.org

Make WordPress Core

Changes between Initial Version and Version 9 of Ticket #15004


Ignore:
Timestamp:
07/10/12 14:03:15 (22 months 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.