Autoloading database tables

  • Resolved Sea Jay

    (@jcollier)


    4 years, 6 months ago

    Hi!

    After a speed analysis, we received this note:

    “Autoload size of the database is a bit high (3.57Mb). The ideal size is less then 1Mb. If it is bigger it won’t be a show stopper, but your site will use more memory for every pageload, which can cause higher memory usage and slowdown. This is mainly caused by Pods – Custom Content Types and Fields plugin. This could also explain the 502 gateway errors. You may contact the plugin author and ask them if autoload on YES is necessary.”

    I don’t have enough knowledge about autoloading to know the relevance or importance of this comment but, if there is guidance, we’ll be happy to make a change.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter Sea Jay

    (@jcollier)

    I did more research and found these large entries in the wp_options table.

    _transient_pods_pods_get_type_post_type-2.7.22 517636
    _transient_pods_1ec153e2e709711909fa5cb228a656e3 377110
    _transient_pods_pods_wp__pod_tableinfo_event-2.7… 350928
    _transient_pods_pods_wp__pod_event-2.7.22 234040
    _transient_pods_pods_wp__pod_preserve-2.7.22 100130
    _transient_pods_pods_get_type_taxonomy-2.7.22 86139
    _transient_pods_72af907bd4e98115b08fe49eea624fda 80086

    These transients are not being removed during housecleaning and they are all being autoloaded. Do they all need to be autoloaded?

    Thread Starter Sea Jay

    (@jcollier)

    For anyone else who may find this post, I should add that Pods > Settings > Clear Pods cache doesn’t empty those tables. If that is what’s supposed to happen, I’d be interesting in commissioning support to find out why not.

    Thread Starter Sea Jay

    (@jcollier)

    Hi @keraweb

    Do you have any suggestions?

    Plugin Author Jory Hogeveen

    (@keraweb)

    Hello @jcollier

    My first guess is that these transients orphaned for some reason.
    Transients are never mandatory data and can be removed without issues.

    @sc0ttkclark , could you elaborate on these orphaned transients and why they aren’t cleared when removing Pods Cache?

    Cheers, Jory

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    I’ve been looking into this the past week while doing a few other tasks. Thanks for your patience, I’m still digging into a potential solution for you.

    Thread Starter Sea Jay

    (@jcollier)

    Thanks to you both for looking into this!

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    My solution is still up in the air right now, it won’t be in the next release. We’re going to figure out which transients should be autoload-able and which should bypass that (when using an external object cache).

    That will be followed up as part of https://github.com/pods-framework/pods/pull/5846

    Thread Starter Sea Jay

    (@jcollier)

    Thanks so much for looking into this. I’ve subscribed to the GitHub ticket to follow and learn.

    Plugin Author Jory Hogeveen

    (@keraweb)

    Closing topic here in favor of GitHub!
    Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Autoloading database tables’ is closed to new replies.