[wp-trac] [WordPress Trac] #19973: Query Maxing Out CPU

[WordPress Trac]

#19973: Query Maxing Out CPU
--------------------------+------------------------------
 Reporter:  ballhogjoni   |       Owner:  ballhogjoni
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  3.3.1
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------------------
Changes (by scribu):

 * severity:  critical => normal


Comment:

 Well, one idea would be to avoid the wp_posts table altogether; just join
 postmeta with wp_term_relationships. The {{{ORDER BY menu_order}}} is
 completely useless.

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