[wp-hackers] Wordpress Performance

[Ozh]

Two cents from an SQL noob :

Regarding changes you propose form comments.comment_type, 
posts.post_status, posts.comment_status, posts.post_type, term_taxonomy.
taxonomy, for which you suggest an enum() :
I think that not enforcing a short list of types allows for flexibility. 
For instance, anyone can make a plugin that implements new type of 
comments or new type of posts, etc... without having to modify the DB 
structure.

(This said, such a plugin could start off by ALTERing the tables and 
remove such enum() on activation if needed?)

Ozh