top tables in my wp-options

Viewing 2 replies - 1 through 2 (of 2 total)

  • @stixtsr

    Are you saying that this plugin added too many rows in wp_options or something else?

    Plugin Author Janis Elsts

    (@whiteshadow)

    Sorry about the late response, somehow I didn’t see this post until now.

    Most likely, @stixtsr meant that the plugin added one unusually large row to wp_options. The menu settings can get pretty large and the option that the plugin adds (ws_menu_editor) can reach 100 KB or more. If this is causing performance issues, you can make the option smaller by enabling settings compression. Here’s how:

    1. Go to the menu editor page.
    2. Switch to the “Settings” tab.
    3. Scroll down to the “Debugging” section and check this box: “Compress menu configuration data that’s stored in the database”. Save the changes.
    4. Go back to the menu editor tab and click “Save Changes” without changing anything.

    However, keep in mind that there is a performance trade-off here. Enabling compression will make the settings smaller, but it will increase the time it takes to decompress/parse the settings. In some cases, it’s better to leave this option turned off.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘top tables in my wp-options’ is closed to new replies.