Issue with autoloaded data

  • Hello there,

    Doing some maintenance it came to our attention that Admin Menu Editor was the 2nd biggest culprit for our autoloaded data.

    The option ws_menu_editor has 0.37MB of auto-loaded data.

    Why is that? Is it essential? Can we disable autoload? Why does the data gets so big?

    Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Janis Elsts

    (@whiteshadow)

    It’s common for that option to get pretty big if you have a lot of admin menu items and/or lots of custom settings like custom colors for each item, complex role permissions, and so on. The configuration data is stored in a format that’s good for quick parsing but not very efficient in terms of space.

    It’s safe to disable autoload. However, the plugin will still try to load the option at least on every admin page, which means one additional SQL query per page load.

    Another thing you could try is to enable this feature in the “Settings” tab:
    “Compress menu configuration data that’s stored in the database ”

    Then go back to the “Admin Menu” tab and click “Save Changes” (you don’t need to actually change anything there). This should significantly decrease the size of the ws_menu_editor option. The drawback is that the plugin will have to spend more time per page load on decompressing the configuration data. I would recommend running some benchmarks before and after enabling this feature to see if it actually helps or hurts performance.

    • This reply was modified 4 years, 5 months ago by Janis Elsts. Reason: Fixed spelling
    Thread Starter thisisbbc

    (@thisisbbc)

    Hey there,

    Thanks for the response.

    To be honest we’re pretty much only using your plugin to re-order the menus in admin, we don’t use any complex role permissions, custom colors, etc. We inject custom CSS in admin via our child-theme. Is it still expected under those conditions?

    If we can safely disable autoload I’ll do that. I’d be curious to test the compression option but right now I can’t spend too much time on this.

    Thanks again for your help and detailed reply!

    All best,
    B

    Plugin Author Janis Elsts

    (@whiteshadow)

    Is it still expected under those conditions?

    It’s less common, but it still could happen if the site just has a lot of admin menu items.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Issue with autoloaded data’ is closed to new replies.