[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:  chriscct7
     Type:  enhancement                          |      Status:  reopened
 Priority:  normal                               |   Milestone:  Awaiting
                                                 |  Review
Component:  Query                                |     Version:  3.1
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch needs-testing needs-       |     Focuses:
  refresh bulk-reopened                          |  performance
-------------------------------------------------+-------------------------

Comment (by seanleavey):

 Replying to [comment:58 talldanwp]:
 > On #46459 the workaround applied in #25238 was mentioned. It appears
 that the workaround for `category__and` could be reverted as part of this
 ticket.
 Note, the workaround is not in ticket 25238, it's in changeset 25238:
 https://core.trac.wordpress.org/changeset/25238

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/16706#comment:59>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform