[wp-trac] [WordPress Trac] #24837: querying optimization for category AND searching

[WordPress Trac]

#24837: querying optimization for category AND searching
-------------------------------------+------------------------------
 Reporter:  robertv123               |       Owner:
     Type:  enhancement              |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  Taxonomy                 |     Version:  3.6
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:
-------------------------------------+------------------------------

Comment (by archon810):

 I was wrong - `USE INDEX(type_status_date)` here doesn't actually resolve
 the issue, and the query still runs for a very long time.

 I've been trying various index approaches but so far I haven't been able
 to get this thing to run fast.

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