Slow database query?

  • Resolved Joe

    (@joewa1980)


    6 years, 10 months ago

    Is it possible that your plugin would great a query similar to this please?

    SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )

    We are experiencing high CPU loads with multiple visitors triggering this query and it reaches a crazy timeout of 600 seconds. Any thoughts? Thank you!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WebberZone

    (@webberzone)

    Is that the full query? I don’t have any INNER JOIN queries that have this.

    A quick way to check this out is to use the Query Monitor plugin to see which queries are generated from which plugin/theme to figure out the one causing an issue

    Thread Starter Joe

    (@joewa1980)

    Thank you for the suggestion, I will add it. I realised it wasn’t your plugin after disabling and deleting it to test it. The mystery continues. Thanks for your help!

    Plugin Author WebberZone

    (@webberzone)

    Glad to hear that. Query Monitor might help figure out the plugin causing the issue.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Slow database query?’ is closed to new replies.