[wp-trac] [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:  highest omg bbq  |   Milestone:  2.7      
Component:  Optimization     |     Version:  2.5      
 Severity:  major            |    Keywords:           
-----------------------------+----------------------------------------------
 Hi, a lot of people are complaining in the forums that since they updated
 from Wordpress 2.3.1 to 2.5 they pages started to use a huge ammount of
 queries and cpu time to be shown. This problems is happening mainly with
 nested pages (at least for me).[[BR]]

 While using the debug-queries plugin, I get the following report:[[BR]]
 4.29153442383E-05 SELECT post_parent FROM wp_posts WHERE ID= '286' LIMIT
 1[[BR]]
 4.19616699219E-05 SELECT post_parent FROM wp_posts WHERE ID= '286' LIMIT
 1[[BR]]
 4.6968460083E-05 SELECT post_parent FROM wp_posts WHERE ID= '286' LIMIT
 1[[BR]]
 4.19616699219E-05 SELECT post_parent FROM wp_posts WHERE ID= '287' LIMIT
 1[[BR]]
 4.19616699219E-05 SELECT post_parent FROM wp_posts WHERE ID= '286' LIMIT
 1[[BR]]
 4.41074371338E-05 SELECT post_parent FROM wp_posts WHERE ID= '287' LIMIT
 1[[BR]]
 4.29153442383E-05 SELECT post_parent FROM wp_posts WHERE ID= '286' LIMIT
 1[[BR]]
 4.2200088501E-05 SELECT post_parent FROM wp_posts WHERE ID= '286' LIMIT
 1[[BR]]
 (... repeated like 2000~3000 times)[[BR]]
 [[BR]]
 querying my database I found that the posts with the 286 and 287 IDs are
 exaclty the pages above the problematic one. Like:


 {{{
 www.mysite.com/tutorials/psp/somepagehere

 where:
 tutorials: ID 286
 PSP: ID 287
 somepagehere: The page where the high queries usage is shown
 }}}

 I alread tried disabling all my plugins, but the problem still persists,
 so Im pretty sure its some kind of Wordpress bug. I Marked this ticket as
 highest priority because some people are losing their blogs because of
 High CPU usage account termination! If needed, you can check this post
 where many users are complaining about this:

 [http://wordpress.org/support/topic/167000#post-732526]

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