[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:  defect (bug)  |      Status:  accepted
 Priority:  normal        |   Milestone:  3.2
Component:  Performance   |     Version:  3.1
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |
--------------------------+-----------------------

Comment (by scribu):

 In #17488, it was suggested that we should do two separate queries.

 However, we know that if you have a large amount of posts, it can lead to
 segfaults, by having to concatenate all the ids into a single string.

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