[wp-trac] Re: [WordPress Trac] #7761: Unnecessary SQL causing slowdown for large sites

[WordPress Trac]

#7761: Unnecessary SQL causing slowdown for large sites
--------------------------+-------------------------------------------------
 Reporter:  Otto42        |        Owner:  anonymous
     Type:  defect        |       Status:  new      
 Priority:  normal        |    Milestone:  2.7      
Component:  Optimization  |      Version:  2.6.1    
 Severity:  normal        |   Resolution:           
 Keywords:                |  
--------------------------+-------------------------------------------------
Comment (by Otto42):

 Replying to [comment:2 ryan]:
 > Note that category_not_in uses a subquery if the DB version supports it.
 See #7599.

 Yes, I noticed that recent change, but the problem still exists. Even with
 the subquery, the GROUP BY clause is unnecessary, as it's using "posts.ID
 NOT IN (subquery)", which is not substantially any different than
 "posts.ID NOT IN (list of post numbers)" for this purpose.

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