[wp-trac] [WordPress Trac] #55942: Add a "type" field to the meta and options tables
WordPress Trac
noreply at wordpress.org
Fri Mar 10 00:07:16 UTC 2023
#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
More information about the wp-trac
mailing list