Significant performance fail for big sites

  • Resolved Sound Strategies

    (@soundstrategies)


    3 years, 3 months ago

    Dear Support,

    Your recent plugin updates causes a lot of inefficient and overloading MySQL queries like:
    SELECT post_id, meta_value FROM wp_postmeta WHERE meta_key = ‘_wp_attached_file’ AND meta_value = ‘2021/01/xxx-logo.png’

    that runs for/when logo specified in search appearance settings.
    It also runs for other images, with lower intensity (maybe for featured images).

    The issue is that meta_value of wp_postmeta is not indexed, and for big sites there is a lot of such queries in queue which are overloading the server.
    Rollback to v3 resolves this issue.

Viewing 1 replies (of 1 total)
  • Plugin Author arnaudbroes

    (@arnaudbroes)

    3 years, 3 months ago

    Hey @soundstrategies,

    I’ve opened an issue so we can look into this. Just like many other plugins, we use the attachment_url_to_postid function in some places. However, there’s a trac ticket open for it because it’s very slow – https://core.trac.wordpress.org/ticket/41281

    I’m going to look if we can add some caching or other improvements for it on our end, but unfortunately that won’t be a quick fix.

    – Arnaud

Viewing 1 replies (of 1 total)
  • The topic ‘Significant performance fail for big sites’ is closed to new replies.