[wp-hackers] Wordpress Performance

[Casey Bisson]

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:

http://trac.wordpress.org/browser/tags/1.5/wp-admin/upgrade-schema.php
http://trac.wordpress.org/browser/tags/2.7/wp-admin/includes/schema.php

--Casey

http://about.Scriblio.net/
http://MaisonBisson.com/