[wp-trac] [WordPress Trac] #33376: Create index on user_email and UNIQUE on user_nicename, user_email and user_login

[WordPress Trac]

#33376: Create index on user_email and UNIQUE on user_nicename, user_email and
user_login
------------------------------------+-----------------------------
 Reporter:  chriscct7               |       Owner:  chriscct7
     Type:  enhancement             |      Status:  assigned
 Priority:  normal                  |   Milestone:  Future Release
Component:  Database                |     Version:
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:  performance
------------------------------------+-----------------------------

Comment (by jorbin):

 In theory, these changes sound like they will improve performance, but I
 would like to see some actual benchmarks vs both MyISAM and Innodb.

 The unique changes for one worry me. While core hasn't directly supported
 non-unique user_email, it is something that I know many installs have
 supported. I would be especially hesitant to essentially remove the
 ability for this to function without some clear numbers showing a lot of
 benefit.

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