After reading some information about the latest Wordpress 2.0.5 release candidate from Dougal Campbell posts and saw some not important bugs at Wordpress Trac (although it did say high priority) regarding post_status index not being created if you’re installing a fresh Wordpress 2.0.4 and confirmed it by looking at the Wordpress Codex Database Description under posts table.
It seems that fresh Wordpress 2.0.4 installation did not create Index for post status .. and if you have a large sites with over 10.000 post this may affect your performance (don’t know much about it because my site is not a big site like that), but i think it’s worth to fix it manually by creating the index for post_status for my own site and several friends site that’s running Wordpress too .. actually i’ve already created the post_status index before posting this :P
Leave a response
Good post.