[wp-trac] [WordPress Trac] #63893: wp_usermeta – Unique Key (user_id+meta_key) - efficiency goal

[WordPress Trac]

#63893: wp_usermeta – Unique Key (user_id+meta_key) - efficiency goal
------------------------------+--------------------------------------------
 Reporter:  curtisfraser      |       Owner:  (none)
     Type:  enhancement       |      Status:  closed
 Priority:  normal            |   Milestone:
Component:  Options, Meta     |     Version:
  APIs                        |
 Severity:  normal            |  Resolution:  wontfix
 Keywords:  close 2nd-        |     Focuses:  performance, coding-standards
  opinion                     |
------------------------------+--------------------------------------------
Changes (by peterwilsoncc):

 * status:  new => closed
 * resolution:   => wontfix
 * version:  6.8.2 =>
 * component:  Users => Options, Meta APIs
 * milestone:  Awaiting Review =>


Comment:

 I agree with @siliconforks that this isn't something that can change in
 WordPress for the reason mentioned: the meta data APIs are designed to
 allow for multiple items with the same key to be stored against a single
 object (in this case a user).

 While using a shorter field for the meta_key may be possible in some or
 even many cases, making the change would be a backward compatibility break
 as there's no way to be sure that of the many, many WordPress sites they
 all contain meta keys under 150 characters.

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