[wp-trac] [WordPress Trac] #33376: Create index on user_email
WordPress Trac
noreply at wordpress.org
Tue Feb 23 22:20:39 UTC 2016
#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
More information about the wp-trac
mailing list