[wp-trac] [WordPress Trac] #30048: wp_options > option_name length

WordPress Trac noreply at wordpress.org
Mon Oct 20 12:00:33 UTC 2014


#30048: wp_options > option_name length
--------------------------+-----------------------------
 Reporter:  akshay_raje   |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.0
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 In the structure of wp_options, the option_name length is varchar(64).

 It makes sense to change this to varchar(255) for the following reasons:

 * To make it inline with wp_postmeta and wp_usermeta schema
 * As the table is also used to store transient data (in absence of object
 cache plugins etc), 64 characters is often less for md5 hash based keys
 leading to cache misses.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/30048>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list