WP_options with lots of autoload = yes

  • Resolved pfm

    (@pfm)


    3 months, 3 weeks ago

    As the WP_OPTIONS tables gets bigger and bigger I got a warning that there are too many options with autoload = yes. I had a look and top 1 is WPPA:

    wppa (365 entries, autoload=yes)

    Is there a way to disable some of them that I might not need to speed up the page loading?

    Thank you.

    • This topic was modified 3 months, 3 weeks ago by pfm.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    A simple test on my dev site gave:
    When autoload is off, wppa requires 488 queries, in the normal situation only 28 to load the frontpage.

    So, do you really want that???

    Aoart from a few user dependant options, only settings that are not set to the default have an option item in the options table.

    Where is the warning coming from??

    Thread Starter pfm

    (@pfm)

    Dear Jacob,

    thank you for your insights. The Warning comes from WordPress “Site Health”. I found several recommendations to keep the wp_options table clean (some plugins leave garbagge in when deinstalled and some leave temporary stuff in). The recommendation is to have not too much autoload to “on” as far as I understood.

    As I’m a user for approx. 10 years for your great plugin, there might be stuff in that I never used but did “play around” with the settings (so they are no longer default). If I understand you correct, going back to default would delete the unused entries? 365 sounds for a lot of “not default” entries. Is this a common amount of special options?

    I’m not 100% sure, but I think site health gives the warning at approx. 1200+ entries. I reduced my entries by deleting some “temporary” and some misused entries (some plugins write whole paragraphs as values). So I’m beneath the warning but if it makes sense (performance wise) I would “clean up” inside my WPPA settings as well.

    Thank you!

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Yes, if you revert to default setting, it deletes the option entry.

    Nevertheless, you turned on my thinking mechanism that leads me to the following plan for a future version (maybe not next week):

    That i will save the array of non-default wppa options as one entry (array will be serialized automatically); makes it faster but theoretically prone for overflow when large entries are entered for e.g. default photo description or custom php procs. Maybe only the yes/no switches possibly all (should not be too big) or non-default only.

    Takes som more thinking and coding, especially conversion to this approach. Keeps me from the street, as we say in Holland…

    Thread Starter pfm

    (@pfm)

    Thank you Jacob!

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.