[wp-trac] [WordPress Trac] #55942: Add a "type" field to the meta and options tables

[WordPress Trac]

#55942: Add a "type" field to the meta and options tables
-------------------------------------------------+-------------------------
 Reporter:  azaozz                               |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  6.3
Component:  Database                             |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:
  testing                                        |  performance
-------------------------------------------------+-------------------------

Comment (by OllieJones):

 A couple of points to consider:

 1. Avoid ENUMs. Altering tables to add values to them is unreasonably
 expensive.

 2. Don't forget about the availability of
 [igbinary_serialize()](https://www.php.net/manual/en/function.igbinary-
 serialize.php) and its unserialize counterpart. It's not on all php
 systems. But when it is, it saves lots of space. Of course using it makes
 it impossible to use LIKE to search metavalues, like the All Users panel
 does. https://github.com/WordPress/wordpress-develop/blob/6.2/src/wp-
 includes/class-wp-user-query.php#L517

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