Is it safe to not autoload the option tablepress_tables?

  • Resolved alduinwf

    (@alduinwf)


    3 weeks, 2 days ago

    Hi there,

    I have quite a lot of tables (about 20k), and WordPress moans that I autoload too many options. I should look if there are options I can “not” autoload so memory consumption goes below 800 KB.

    So I did the Google and found a query that shows me the biggest autoload options, and on top was “tablepress_tables” (350 KB) (followed by “_transient_dirsize_cache” (280 KB).

    I think I know what this option is for, but I wonder if it would be safe to set autoload to off for it.

    Safe as in: Can the plugin survive with it off? And: Will the plugin not turn it on again?

    I’ve grepped through the code, and I don’t think I saw that it’ll autoload this option with an explicit priority. So I guess maybe that it’s set to “yes” is grandfathered from some older version?

    According to the WordPress dev doc, not specifying the autoload priority will default to “auto” and thus let WP decide whether or not to autoload the option. So I guess it should be safe. Question mark?

    In any case, thank you for your work and happy holidays. 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    3 weeks, 2 days ago

    Hi @alduinwf,

    Thanks for your question!

    TablePress does indeed leave the decision for auto-loading this option to WordPress, so I assume that it decided to auto-load it on your site. However, auto-loading this option is not needed, so you could definitely try turning that off! The worst-case result will be that there’s simply another request to the database for this option, whenever a table is loaded.

    If this turns out to result in worse performance than right now, you can always turn auto-loading back on.

    Best wishes,
    Tobias

    Thread Starter alduinwf

    (@alduinwf)

    3 weeks, 2 days ago

    Hi Tobias,

    thanks for the quick response!

    It was actually set to “yes”, so I guess it came from a time long ago when “yes” and “no” were the correct settings (instead of “on”/”off”/”auto”), and “yes” was the default option if not specified otherwise (which TablePress seems not to).

    I’ve set it to “off” for now, and it doesn’t seem to be exploding. And if it needs those options, it can gladly fire that one query for all I care. 🙂

    Thank you! 🙂

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    3 weeks, 2 days ago

    Hi @alduinwf,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress in the plugin directory. Thanks!

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

You must be logged in to reply to this topic.