[wp-testers] 2.0.5 in the works
Brian at TheCodeCave.com
Tue Sep 26 20:19:13 GMT 2006
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
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...
More information about the wp-testers