[wpmu-trac] [WordPress MU Trac] #1080: Loading and saving the edit page screen causes 1100+ MySQL db queries

[WordPress MU Trac]

#1080: Loading and saving the edit page screen causes 1100+ MySQL db queries
----------------------------+-----------------------------------------------
 Reporter:  jamescollins    |       Owner:  somebody
     Type:  defect          |      Status:  new     
 Priority:  normal          |   Milestone:          
Component:  Administration  |     Version:  2.8.2   
 Severity:  normal          |    Keywords:          
----------------------------+-----------------------------------------------
 I'm encountering huge performance issues on a WPMU blog that has 250
 pages.

 Loading the edit page screen causes 1100+ db queries. Actually editing a
 page causes around the same.

 I've nailed it down to [1778] which is causing all the queries. If I
 comment out that flush rewrite rules line, the query count drops to around
 80 instead.

 Donncha, can you remember why you added that line specifically?

 The line causes the rewrite rules to be flushed on both the initial load
 of the edit page screen, and also after saving the edit page screen

 If you comment out the line above, the rewrite rules are still flushed
 correctly by WP's internals.

 So I don't think we need the $wp_rewrite->flush_rules() call at all in wp-
 admin/includes/mu.php.

 I am using the WP Tuner plugin
 (http://wordpress.org/extend/plugins/wptuner/) to view the db queries
 before and after the change.

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/1080>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser