[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:  Future
                                                 |  Release
Component:  Database                             |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:
  testing                                        |  performance
-------------------------------------------------+-------------------------

Comment (by azaozz):

 Replying to [comment:27 rjasdfiii]:
 > EAV, and the lack of good indexing, is a big performance issue _today_
 for WP.

 Perhaps you mean the lack of fulltext indexes for meta and option value?
 This seems to be discussed at length in few places, like:
 https://github.com/WordPress/performance/issues/132. Don't think this
 ticket has anything to do with DB indexes.

 > So, I am telling you that your design, though inspired, will be a
 nightmare of coding clumsiness and performance degradation.
 >
 > _Be aware that almost any embellishment in this area will lead to the
 inability to use an `INDEX`_  That, alone, dooms any performance.

 Perhaps there is a bit of misunderstanding here? This ticket is not about
 changing any fields in the DB. It is only about adding another column that
 would hold the PHP type of the data. This will significantly reduce use of
 functions like `maybe_unserialize()`. That's all.

 Also storing the (PHP) type may make it easier to search for specific
 data, i.e. can limit the searches by data type.

 > I claim that `postmeta` is already in deep-dodo because of performance.
 This plugin helps by...

 Again, nothing to do with this ticket :)

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