Slow queries

  • Hi,
    We’ve had to disable WPSSO on our site. When we have WPSSO active our publishing and work in the backend is horribly slow. Publishing results in lost connections after the post has published and also while working on posts and our Litespeed cache log has hundreds of entries showing WPSSO slow queries.

    Without WPSSO we don’t get the slow queries and publishing isn’t disrupted. We’re currently getting basic schema information on our posts from Rank Math. If we disable Rank Math and activate WPSSO the slow queries still occur.

    Any suggestions on this please?

    Thank you

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

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

    (@jsmoriss)

    It sounds like your database, and specifically your options table, needs to be optimized. WordPress stores transient cache objects in the options table by default, and slow options table queries would create the issue you describe. I would suggest 1) tuning your database, 2) using a plugin like the Query Monitor to check performance issues, and 3) if you cannot fix your database performance, then turn off WPSSO’s use of the WordPress transient cache under the SSO > Advanced Settings > Cache tab (set the “Head Markup Cache Expiry” option to 0).

    See here for more info on the WordPress transient cache: https://www.google.com/search?q=wordpress+transient+cache

    Performance issues can also be caused by badly coded content filters, so you could try disabling the SSO > Advanced > Content and Text > Use WordPress Content Filters option.

    See here for more info on that: https://wpsso.com/docs/plugins/wpsso/installation/troubleshooting-guide/

    js.

    Thread Starter aseannewstoday

    (@aecnews)

    Thank you very much JS.

    I will try all that. I did contract someone to tune the database, but…

    Thank you very much for the information ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Slow queries’ is closed to new replies.