[wp-trac] [WordPress Trac] #17031: Saving navigation menu items is slow

[WordPress Trac]

#17031: Saving navigation menu items is slow
-------------------------------+------------------------------
 Reporter:  pellaeon           |       Owner:
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Menus              |     Version:  3.1
 Severity:  normal             |  Resolution:
 Keywords:  reporter-feedback  |
-------------------------------+------------------------------

Comment (by pellaeon):

 I cannot reproduce the "blank page" problem and 500 internal server error,
 so please just ignore that.

 With WP_DEBUG set to false, the nav-menu could be saved successfully. (but
 it takes about 30 seconds)
 With WP_DEBUG set to true, it could still be saved successfully, without
 any error messages.

 I've looked into the mysql query log. I'm surprised to found that it takes
 about 2250 queries to save the nav-menu, no wonder it's so slow.

 It even UPDATE some post contents... Why would it need that?...

 MySQL query log: [http://cnmc24.hs.ntnu.edu.tw/tmp/cnmc30.log]

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