[wp-hackers] Wordpress Performance
casey.bisson at gmail.com
Mon Dec 15 15:11:43 GMT 2008
My specific thoughts echo what Ozh noted: the term_taxonomy table
needs to support an arbitrary number of values to effectively support
the extensibility that makes WordPress an application platform as well
as blog system.
More generally, however, I'm split about how important it is to
convert any field to enum. Yes it makes tables smaller, but it doesn't
change the index size (indexing x different varchar values is the same
as indexing an equal number of enum values). And without more
efficient indexes, we're unlikely to see any performance gain.
I'm guessing the core developers have come to a similar conclusion.
You can compare the number of enums in 1.5 vs. 2.7 here:
More information about the wp-hackers