15.1: Slow query in WordPress Admin

  • Resolved janvitos

    (@janvitos)


    4 years, 9 months ago

    Hi,

    I just updated to Yoast SEO 15.1 and noticed there is a slow query that is slowing down all page loads in the WordPress Admin.

    Here is the query info:

    
SELECT COUNT(ID)
FROM wp_posts
WHERE ID NOT IN (
SELECT object_id
FROM wp_yoast_indexable
WHERE object_type = 'post'
AND permalink_hash IS NOT NULL )
AND post_type IN ('post', 'page', 'attachment')	+
Yoast\W\S\A\I\Indexable_Post_Indexation_Action->get_total_unindexed()
Plugin: wordpress-seo	1	0.2561

    As you can see, the query is taking 0.256 seconds to execute.

    Thanks.

    • This topic was modified 4 years, 9 months ago by janvitos.
    • This topic was modified 4 years, 9 months ago by janvitos.
Viewing 13 replies - 1 through 13 (of 13 total)
  • Rumejan

    (@onlyincebu)

    4 years, 9 months ago

    Hello!

    Sorry for the trouble. Can you please check if there are Javascript errors in your browser’s console? If there are, please provide us a screenshot.

    Thread Starter janvitos

    (@janvitos)

    4 years, 9 months ago

    Hi,

    There are no Javascript errors in the console.

    And just so you know, Yoast SEO 15.0 did not generate this slow query. It has only started happening in Yoast SEO 15.1.

    • This reply was modified 4 years, 9 months ago by janvitos.
    • This reply was modified 4 years, 9 months ago by janvitos.
    Suwash

    (@suascat_wp)

    4 years, 9 months ago

    @janvitos,

    Would you please provide us with some information about your WordPress setup:

    – Does the issue occur with the current version of WordPress v5.5.1?
    – Are all your non-Yoast plugins and themes also updated?
    – Does your site meet the plugin requirements?

    Thread Starter janvitos

    (@janvitos)

    4 years, 8 months ago

    – It occurs with WordPress 5.5.1
    – All plugins are updated
    – My site meets all the plugin requirements

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    4 years, 8 months ago

    We are sorry to hear that you are having trouble with the Yoast SEO v15.1 and it’s must be frustrating for you. Let’s see what’s going on here.

    We understand that Yoast SEO v15.1 significantly slows down your website dashboard. Can you please confirm whether the issue occurs on all the available pages on your site dashboard or is it specific to certain pages only (i.e. edit page)?

    In addition, can you please confirm whether you have performed SEO data optimization from the Yoast SEO → Tools page yet? If not, can you please perform the relevant analysis to see whether this resolves the issue for you?

    We look forward to hearing from you.

    Thread Starter janvitos

    (@janvitos)

    4 years, 8 months ago

    The issue occurs on the Dashboard, Plugins and SEO Admin pages.

    Data optimization has been completed: SEO data optimization complete.

    • This reply was modified 4 years, 8 months ago by janvitos.
    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    4 years, 8 months ago

    Thanks for your confirmation. Can you please confirm how many posts or pages do you have on your website?

    Thread Starter janvitos

    (@janvitos)

    4 years, 8 months ago

    I have 6050 Posts and 2 Pages.

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    4 years, 8 months ago

    We appreciate you for bringing this to our attention. The issue you are currently experiencing is a known bug that we are already aware of where the plugin slows down the website the site has bulk posts or pages like you do. Our development teams are currently investigating the issue on our end. You can find the relevant issue report and track the progress of it from here https://github.com/Yoast/wordpress-seo/issues/15341.

    We apologies for any inconvenience about this.

    Thread Starter janvitos

    (@janvitos)

    4 years, 8 months ago

    Ok, I understand.

    I thought the issue started happening in 15.1, but I guess I hadn’t noticed it in previous versions.

    I will wait for the issue to be resolved then. But it has been ongoing since May, so I doubt it will be fixed any time soon.

    It is very unfortunate as the Dashboard is very slow with this plugin active.

    • This reply was modified 4 years, 8 months ago by janvitos.
    Thread Starter janvitos

    (@janvitos)

    4 years, 8 months ago

    Closed.

    Thread Starter janvitos

    (@janvitos)

    4 years, 8 months ago

    For the record, resetting indexables & migrations with the Yoast Test Helper plugin has fixed the issue for me.

    • This reply was modified 4 years, 8 months ago by janvitos.
    • This reply was modified 4 years, 8 months ago by janvitos.
    Rookie

    (@alriksson)

    4 years, 8 months ago

    Look into this bloated script though:
    https://github.com/Yoast/wordpress-seo/issues/14778

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘15.1: Slow query in WordPress Admin’ is closed to new replies.