[wp-trac] Re: [WordPress Trac] #7415: "using filesort" in default install

[WordPress Trac]

#7415: "using filesort" in default install
------------------------------------------------------------+---------------
 Reporter:  dbuser123                                       |        Owner:  anonymous
     Type:  defect (bug)                                    |       Status:  new      
 Priority:  high                                            |    Milestone:  2.8      
Component:  Optimization                                    |      Version:  2.7      
 Severity:  major                                           |   Resolution:           
 Keywords:  database, optimization, slow queries, filesort  |  
------------------------------------------------------------+---------------
Comment (by dbuser123):

 >> I believe your assumption is wrong.
 True.

 >> load the entire mess in memory
 Loading 10.000 entries in memory isn't a good idea. Sort buffers mostly
 aren't that large, and the hdd will be used. Does this query ever show up
 without a LIMIT clause anyways?

 >> by using IN ('publish', 'private') rather than the OR statement.
 MySQL doesn't distinguish between IN and OR.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/7415#comment:12>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software