[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
------------------------------------+-----------------------------
Changes (by chriscct7):

 * keywords:  has-patch dev-feedback early => has-patch dev-feedback


Comment:

 While I agree it's not unheard of (Scott's plugin is a great example), the
 question is whether the few users doing something WordPress doesn't
 natively support (5k out of many many millions) and in fact has code to
 prevent against  are enough reason to block a potential performance impact
 for all of the other users (the clear majority of WordPress user's don't
 do that), which would be very significant on large sites with many users
 (particularly when going a get user by email call). While I admit if this
 goes in it makes a plugin like Scott's a bit harder to accomplish, it
 wouldn't be impossible (you could for example store users in a custom user
 table or add a table that maps additional usernames to an email, or
 something along those lines. And the third provided patch takes care of
 users who already share an email via a plugin like that.

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