nav-menus.php update slow for larger menus

  • Resolved Jasonheffner

    (@jasonheffner)


    11 years, 1 month ago

    We noticed that when updating a large menu.. 50+ items that the number of queries and time to complete is too long and can cause the scripts to timeout. This is a large multisite install.

    An example site with with 60 menu items when updated will use 623 queries and take 53.4123 seconds to update. Disabling the sitewide tags plugin decreases this to 448 queries and only 574 milliseconds.

    https://www.ads-software.com/plugins/wordpress-mu-sitewide-tags/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    You’ll have to look for a hook to use to unhook SWT when saving a menu.

    The 53.4123 seconds is indicative that you have an issue in your install.

    – 53412/623 ~ 800 ms per query
    – 574/448 ~ 1.25 ms per query

    Thread Starter Jasonheffner

    (@jasonheffner)

    Thanks Ron. We did end up writing an unhook for nav menu updates. We have over 5000 sites running and tracked it down to an individual query. We will have to see whether it’s a memory issue or query problem on MySQL. Thanks for the response.

    Plugin Author Ron Rennick

    (@wpmuguru)

    Glad you found it ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘nav-menus.php update slow for larger menus’ is closed to new replies.