Lloyd D Budd >"somehow fixed already": Because Trunk continues to evolve -- to >introdude new problems to solve ;-) -- in Trunk I see: > PRIMARY KEY (ID), > KEY post_name (post_name), > KEY type_status_date (post_type,post_status,post_date,ID)
Yes, that's right. I remember looking this up back when I discovered the problem. My next question, was whether or not MySQL's query engine would use that new index in its queries. So, I started looking for information on whether queries that only included a post_status would use a compound index that didn't start with status. Then I decided I needed to first find out if the 2.1 code had added Type to every where clause that included Status. If that were the case it would moot my first question. Then I realized it was 1am and I needed to first get some sleep... Then THAT was the end of the story. Just FYI I did go through the 2.0.4 schema and verified that my older blogs matched it for all other aspects (except for those I tracked down to pluggins). So, this seems to be the only missing index. It just stinks that it was an important one... _______________________________________________ Brian Layman www.TheCodeCave.com _______________________________________________ wp-testers mailing list [email protected] http://lists.automattic.com/mailman/listinfo/wp-testers
