[wp-trac] [WordPress Trac] #16706: Queries using "category__and" are slow on large databases

[WordPress Trac]

#16706: Queries using "category__and" are slow on large databases
-------------------------+-----------------------
 Reporter:  tigertech    |       Owner:  scribu
     Type:  enhancement  |      Status:  accepted
 Priority:  normal       |   Milestone:  3.2
Component:  Performance  |     Version:  3.1
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |
-------------------------+-----------------------

Comment (by ryan):

 With the patch a tag intersection (foo+bar) on a testbed with over 2000
 posts took 49.7ms.  Without the patch the intersection took  7,360.7ms.
 Results seem to be identical.  Sweet patch.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16706#comment:22>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software