[wp-trac] [WordPress Trac] #33376: Create index on user_email

[WordPress Trac]

#33376: Create index on user_email
------------------------------+--------------------------
 Reporter:  chriscct7         |       Owner:  chriscct7
     Type:  enhancement       |      Status:  assigned
 Priority:  normal            |   Milestone:  4.5
Component:  Database          |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |     Focuses:  performance
------------------------------+--------------------------
Changes (by pento):

 * keywords:  has-patch needs-refresh => has-patch commit
 * milestone:  Future Release => 4.5


Comment:

 WP.com has a `UNIQUE` index on `user_email`, but I'm inclined to agree
 that we can't practically do that for all sites. Also, enforcing `UNIQUE`
 keys has burned us in the past when we later decide to make something
 non-`UNIQUE`.

 The performance difference between `UNIQUE` and non-`UNIQUE` indexes is
 negligible, so let's commit [attachment:33376.2.patch] (with
 `$wp_db_version` bump, of course).

--
Ticket URL: <https://core.trac.wordpress.org/ticket/33376#comment:13>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform