Autoloaded keys in wp_options table

  • Resolved motionception

    (@duncanroygreenwood)


    1 year, 5 months ago

    Hi,

    I’ve noticed that there is a bunch of autoloaded entries in my wp_options table that Advanced Woo Search must have made.

    All the rows have a name value starting with “aws_search_term_”. Some of them are over 150KiB in size, and some of them are 64KiB.

    So just looking at the biggest 7 of these entries, they’re adding over 600KiB to my autoloaded options, which loads on every page. The total autoloaded options should never be more than 1MiB…

    Is it safe for me to delete these entries? Or at least take them off autoload? If I delete or turn off autoload, will they be added back by the plugin?

    If possible, could you please make sure that AWS Search doesn’t add so much to autoloaded wp_options in the future? I’m not sure how old these entries are, so it’s possible that this has already been fixed.

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    Hi,

    Please tell me – what plugin version number you are currently using. This problem with autoloads was actual for a very old plugin version and for now is not actual anymore.

    You can update to the latest plugin version and safely remove all these options.

    Regards

    Thread Starter motionception

    (@duncanroygreenwood)

    I’m currently on 2.86. Updating to 2.88 now.

    I have been using AWS for about 6-7 years, so maybe left behind by an old version?

    Just to confirm:
    When you say “update to the latest plugin version and safely remove all these options” you mean that mean I can delete the entries safely after updating?

    Plugin Author ILLID

    (@mihail-barinov)

    Yes, you can remove all those aws_search_term_ options from the wp_options table. Apparently they were left over from when you were using the old version of the plugin.

    Thread Starter motionception

    (@duncanroygreenwood)

    Awesome. Done. Thanks.

    One last thing. There are other AWS entries in the options table. I’ll paste a list:

    aws_settings
    widget_aws_widget
    aws_plugin_ver
    aws_hide_welcome_notice
    aws_reindex_version

    Can you tell me if any of those are left by previous versions? And if they can be removed or taken off autoload?
    (aws_hide_welcome_notice is the only one with autoload = off)

    Your plugin is the best, by the way ??

    Plugin Author ILLID

    (@mihail-barinov)

    No, these options do not need to be touched.

    Thanks for your kind words ??

    Thread Starter motionception

    (@duncanroygreenwood)

    Awesome. Thanks ??

    I’m clicking that checkbox down there to mark this as resolved.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Autoloaded keys in wp_options table’ is closed to new replies.