Slow queries

  • Resolved igears

    (@igears)


    4 years ago

    Hi,

    I have installed the query monitor plugin and it reports a couple of duplicate querys as well as a couple of slow queries from Yoast. Below is an example of a slow query:

    SELECT COUNT(term_id)
FROM wpdc_term_taxonomy
WHERE term_id NOT IN (
SELECT object_id
FROM wpdc_yoast_indexable
WHERE object_type = 'term'
AND permalink_hash IS NOT NULL )
AND taxonomy IN ('category', 'post_tag', 'post_format', 'product_cat', 'product_tag', 'product_shipping_class')

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    We are sorry to hear that you are having trouble with our plugin. Can you please confirm whether you have performed the SEO data optimization from the SEO → Tools page? If not, please run the relevant analysis to see whether this improves anything.

    However, if you have already performed the relevant analysis but you are still seeing the duplicate queries in the Query Monitor plugin, we recommend you please try resetting the Indexables tables and migrations by using the Yoast Test Helper. You can find the relevant steps given below:

    • Go to Tools → Yoast Test → Yoast SEO → Reset Indexables tables & migrations options to reset it.
    • Run the SEO data optimization again from the Yoast SEO → Tools page to see whether this improves the relevant slow queries.

    Last but not least, can you please confirm on which exact page you are seeing the relevant duplicate queries in the Query Monitor plugin?

    We look forward to hearing from you.

    Plugin Support devnihil

    (@devnihil)

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

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