• Resolved philraymond

    (@philraymond)


    I notice your plugin generates 12 queries on my homepage and I’m not even using any snippets there.

    8 of the queries are duplicates:

    SELECT wp_posts.ID, wp_posts.post_content, p2.meta_value as priority
    FROM wp_posts
    INNER JOIN wp_postmeta p1
    ON (wp_posts.ID = p1.post_id)
    INNER JOIN wp_postmeta p2
    ON (wp_posts.ID = p2.post_id)
    WHERE (( p1.meta_key = ‘wbcr_inp_snippet_scope’
    AND p1.meta_value = ‘auto’)
    AND p2.meta_key = ‘wbcr_inp_snippet_priority’ )
    AND wp_posts.post_type = ‘wbcr-snippets’
    AND (wp_posts.post_status = ‘publish’)
    ORDER BY CAST(priority AS UNSIGNED) ASC

    Is there some way to eliminate many of these queries?

    Thanks!

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter philraymond

    (@philraymond)

    Looking at a post, the ‘query monitor’ plugin says you’re making 322 calls, 314 of them to “WINP_Execute_Snippet->executeCommentsSnippets()”.

    There are indeed 314 comments on the page but I’m confused as to why your plugin has anything to do with that?

    Hello.

    Sorry for the long answer. We were dealing with the problem.
    We plan to optimize the plugin in the next updates.

    Thread Starter philraymond

    (@philraymond)

    Do you have any guess as to when this will be fixed? Thanks 🙂

    Hello, in version 2.4, this is fixed

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘So Many Queries’ is closed to new replies.