Performance Issues – database autoload

  • Resolved jrgodoi

    (@jrgodoi)


    8 years ago

    There’s an autoload option that is causing performance issues in my website. It’s really needed to put all the google fonts in the option table? There’s a way to disable this? I’m not using any google font.

    SELECT LENGTH(option_value),option_name FROM wp_options WHERE autoload="yes" ORDER BY length(option_value) DESC LIMIT 20

    LENGTH(option_value)    option_name
334603                  _site_transient_popmake-google-fonts-list
262939                  dikka_options
255003                  dikka_options-transients
27238                   jetpack_file_data
22589

    https://wordpress.org/plugins/popup-maker/

Viewing 1 replies (of 1 total)
  • Plugin Author Daniel Iser

    (@danieliser)

    8 years ago

    @jrgodoi – That is about the only place we can store them, so yea it is needed, but we can set it to not auto load. That isn’t needed anywhere but in the popup theme editor to generate the list of google font options. You should be able to safely set it to auto load no.

    Google font apis only allow for a limited number of pulls for each API key, so to keep from overusing it the fonts have to be stored locally for a period of time.

    Also that key looking at it now is not an option, but a transient(notice it begins with _). That means it deletes itself occasionally to refresh it.

    https://codex.wordpress.org/Function_Reference/set_transient

    That said per WordPress documentation transients with an expiration are never autoloaded so it shouldn’t be affecting you at all really.

    NB: transients that never expire are autoloaded, whereas transients with an expiration time are not autoloaded.
    https://codex.wordpress.org/Function_Reference/set_transient

Viewing 1 replies (of 1 total)
  • The topic ‘Performance Issues – database autoload’ is closed to new replies.