I've got a site with 1200 groups, 1200 OG Menus, and about 32,000 menu items.
node/%node/og_menu/%menu/item/%menu_link/edit
was taking > 30seconds to load and was using somewhere between 512–768M of memory.

The problem was that, even though we know that the given menu item exists in %menu, menu_edit_item() loads all 1200 menus to find the one with this menu item.

Patch forthcoming.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

dalin created an issue. See original summary.

dalin’s picture

This site is on the 2.x branch. We have an upgrade to 3.x planned. I'm guessing that this problem applies to both branches, but I'm not sure.

This includes a patch for the core Menu module. It would be great to get some feedback on this here before adding an issue to Core.

dalin’s picture

dalin’s picture

Assigned: dalin » Unassigned
dalin’s picture

FileSize
729 bytes

Oops, here's a patch that doesn't include my memory limit hack.

rv0’s picture

Version: 7.x-2.x-dev » 7.x-3.x-dev
Category: Bug report » Feature request
Priority: Major » Normal

I don't think there's a big chance for this change to be included in D7 core at this point.

I'm also not sure your solution does not break/lose functionality.
As mentioned in the other issue I still think the best solution is something ajax-y that does all the heavy lifting on demand and replaces the core menu behavior.. This could be handled in contrib and be completely separate from OG Menu.

I'm open to further ideas/suggestions, though my time for this is very limited at this moment.