[wp-trac] Re: [WordPress Trac] #6702: Raise in the Wordpress number of queries in nested pages

[WordPress Trac]

#6702: Raise in the Wordpress number of queries in nested pages
--------------------------+-------------------------------------------------
 Reporter:  tiosolid      |        Owner:  anonymous
     Type:  defect        |       Status:  new      
 Priority:  high          |    Milestone:  2.7      
Component:  Optimization  |      Version:  2.5      
 Severity:  major         |   Resolution:           
 Keywords:                |  
--------------------------+-------------------------------------------------
Comment (by tiosolid):

 Thanks for the plugin. According to the plugin's dump (I took out the
 "normal" queries and started the dump from the strange ones):

 {{{
     [20] => Array
         (
             [0] => SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN
 wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN
 ('category')  AND ( t.term_id <> 58 ) ORDER BY t.name ASC
             [1] => 9.10758972168E-05
             [2] => get_terms
         )

     [21] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '286'
 LIMIT 1
             [1] => 7.89165496826E-05
             [2] => _get_post_ancestors
         )

     [22] => Array
         (
             [0] => SELECT * FROM wp_posts  WHERE (post_type = 'page' AND
 post_status = 'publish')    ORDER BY menu_order, post_title ASC
             [1] => 0.00259494781494
             [2] => get_pages
         )

     [23] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '286'
 LIMIT 1
             [1] => 0.000121831893921
             [2] => _get_post_ancestors
         )

     [24] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '287'
 LIMIT 1
             [1] => 4.79221343994E-05
             [2] => _get_post_ancestors
         )

     [25] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '286'
 LIMIT 1
             [1] => 4.10079956055E-05
             [2] => _get_post_ancestors
         )

     [26] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '287'
 LIMIT 1
             [1] => 4.10079956055E-05
             [2] => _get_post_ancestors
         )

     [27] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '286'
 LIMIT 1
             [1] => 4.10079956055E-05
             [2] => _get_post_ancestors
         )

     [28] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '286'
 LIMIT 1
             [1] => 4.2200088501E-05
             [2] => _get_post_ancestors
         )

     [29] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '286'
 LIMIT 1
             [1] => 4.81605529785E-05
             [2] => _get_post_ancestors
         )

     [30] => Array
         (
             [0] => SELECT `post_parent` FROM wp_posts WHERE ID= '287'
 LIMIT 1
             [1] => 4.29153442383E-05
             [2] => _get_post_ancestors
         )
 [the same for all the others queries]
 }}}

 On the other pages where the error occours the problematic function is the
 same (_get_post_ancestors)

-- 
Ticket URL: <http://trac.wordpress.org/ticket/6702#comment:4>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software