[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:  3.4
Component:  Performance      |     Version:  3.2.1
 Severity:  normal           |  Resolution:
 Keywords:  early has-patch  |
-----------------------------+--------------------

Comment (by scribu):

 I noticed that the query that fetches the rest of the rows contains the
 {{{$orderby}}} fragment again. This would obviously break when the orderby
 refers to any table other than wp_posts, for example when ordering by a
 meta key.

 Going to use an approach similar to WP_User_Query: fetch only the non-
 cached posts and then populate the posts array according to the order of
 the ids found.

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