[wp-trac] [WordPress Trac] #18536: Improve performance of WP_Query core

[WordPress Trac]

#18536: Improve performance of WP_Query core
-------------------------+------------------------------
 Reporter:  cheald       |       Owner:
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Query        |     Version:  3.2.1
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |
-------------------------+------------------------------

Comment (by nacin):

 Impressive. Related: #10964.

 Unfortunately, not many of our unit tests cover WP_Query. After some bad
 experiences in version 3.1 when we added taxonomy queries, we're not
 likely to significantly alter WP_Query again (for both this ticket and
 #10964, among otherS) until we have them. Building some unit tests for
 WP_Query would be quite the undertaking, but it'd be one that would move
 along tickets like this.

 That said, this does look relatively simple. The main concern would be
 seeing how plugins that hook deeply into WP_Query might be affected.

 Another concern would be figuring out where old and new intersect with
 regards to performance. I imagine for simple queries or smaller datasets,
 the current version would be more performant.

 What's one of your queries that isn't performing well? If you're doing an
 interesting join or sorting or querying by an unindexed field, you might
 be doing a tablesort that you should work to avoid. Can we see some
 EXPLAIN results?

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