• Resolved jamminjames

    (@jamminjames)


    The Query Monitor plugin is consistently warning about these slow db queries by Yoast. Can anything be done about this?

    SELECT term_id
    FROM wp_term_taxonomy AS T
    LEFT JOIN wp_yoast_indexable AS I
    ON T.term_id = I.object_id
    AND I.object_type = 'term'
    AND I.version = 2
    WHERE I.object_id IS NULL
    AND taxonomy IN ('category', 'post_tag', 'ngg_tag')
    LIMIT 26
    Yoast\W\S\A\I\Abstract_Indexing_Action->get_limited_unindexed_count()
    Plugin: wordpress-seo

    SELECT COUNT(P.ID)
    FROM wp_posts AS P
    LEFT JOIN wp_yoast_indexable AS I
    ON P.ID = I.object_id
    AND I.link_count IS NOT NULL
    AND I.object_type = 'post'
    LEFT JOIN wp_yoast_seo_links AS L
    ON L.post_id = P.ID
    AND L.target_indexable_id IS NULL
    AND L.type = 'internal'
    AND L.target_post_id IS NOT NULL
    AND L.target_post_id != 0
    WHERE ( I.object_id IS NULL
    OR L.post_id IS NOT NULL )
    AND P.post_status = 'publish'
    AND P.post_type IN ('post', 'page')
    Yoast\W\S\A\I\Abstract_Indexing_Action->get_total_unindexed()
    Plugin: wordpress-seo
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @jamminjames

    Thanks for reaching out and I’m sorry about the slow query. Can you confirm if you have completed the SEO data optimization in WordPress > Yoast SEO > Tools? If no, please perform the following:

    1. Install & activate the Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations‘, ‘Reset Prominent words calculation‘, and ‘Reset Internal link counter‘ buttons. After each click, the page will reload to confirm that the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Please let us know if the reported issue remains after resetting the optimized data.

    Thread Starter jamminjames

    (@jamminjames)

    Thanks. It did say it was optimized before I started with the Test plugin, but I did as directed and re-scanned afterwards.

    I don’t see those entries in the Query Monitor anymore, so hopefully the problem is solved for good. Thank you!

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

The topic ‘Slow database queries slow down website’ is closed to new replies.