[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 close  |
-----------------------------+------------------------------

Comment (by cheald):

 One possible solution might be as simple as a config switch; the
 administrator could be warned that the switch may break some plugins. It's
 certainly not a perfect solution, but for people with large installs, it
 might be a pretty significant quality-of-experience improvement.

 My first draft of this fix implemented query rewrites as a plugin using
 the posts_request and posts_results filters, but it's a hack of a
 solution, and seems like the sort of thing that belongs in the core
 anyhow. https://github.com/cheald/wp_fasterquery/blob/master/filter.php is
 the plugin, but it's very clearly tailored specifically to our needs and
 install, and may not work well for others.

 While it's possible to fix this with a plugin, it feels like the fact that
 it can happen at all is a somewhat self-limiting design issue that could
 use some more formal resolution. If the team disagrees, that's certainly
 fine, but I felt I'd be remiss if I didn't at least make an attempt! :)

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