Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author JS Morisset

    (@jsmoriss)

    It sounds like WPSSO may be highlighting a performance issue with your database, theme, or plugins. You may want to activate and use the Query Monitor plugin as suggested here https://wpsso.com/docs/plugins/wpsso/installation/troubleshooting-guide/#query-monitor-plugin.

    js.

    Thread Starter go6otel

    (@go6otel)

    “It happens when I add or edit a product in the administration. So far, I only have products with variations, and it happens very often.”

    here is slow queries :

    SELECT?option_name, option_value
    FROM?wp_options
    WHERE?option_name?IN?(‘_transient_wpsso_f_688dfbd47445d251426d8c87da785c30′,’_transient_timeout_wpsso_f_688dfbd47445d251426d8c87da785c30’)

    • This reply was modified 2 months ago by go6otel.
    Plugin Author JS Morisset

    (@jsmoriss)

    If getting a transient from WordPress is being highlighted as a “slow query” then you definitely have a problem with your database – getting a transient, even dozens of them, should not be “slow” – this is a standard basic WordPress feature. See here for more info: https://developer.www.ads-software.com/reference/functions/get_transient/

    js.

    Plugin Author JS Morisset

    (@jsmoriss)

    FYI, since WordPress transients are stored in the options table, you may want to make sure that table is optimized (ie. cleaned and defragmented). See https://www.ads-software.com/plugins/advanced-database-cleaner/ for an example plugin that may help. Make sure you have a database backup before you start. ?? If a transient query is flagged by the Query Monitor as slow, then you may have more serious issues with general database performance – you may also want to report the issue to your hosting provider.

    js.

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