The queries running for the posts for all records vs only for the paginated ones

  • Resolved HireAWiz Web Design

    (@hireawiz)


    3 years, 6 months ago

    Hello,

    We are facing challenges with the site load time and while debugging we identified the Yoast SEO plugins is running queries without considering the paginated results.

    We have 100000+ records in the post table and while reviewing the queries using the Query Monitor plugin, we saw queries ran like:

    SELECT wp_posts.* FROM wp_posts WHERE ID IN (all records for the selected tab)

    https://d.pr/i/kZlfhj

    We have a limit of 100 records to display on the page so not sure why the queries ran by the plugin selects all of the data for the posts that are in the specific tab and by tab I mean (Trashed/Mine/All/Published)

    Just to give clarity on this, if the Trashed tab has 10000 records, the query selects all 10000 vs just selecting the 100 records on that page.

    Similarly, when I try to go the All tab and as you can see in the screenshot I have 118000+ records, the select query tries to fetch all records in one query.

    FYI: We have the latest plugin v15.0 installed on the site.

    I hope this makes sense. Please let me know if there is a setting somewhere that I can update to solve this issue or piece of code that I can add to my theme etc.

    Looking forward to a positive response.

    Thank you
    Malek

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 6 months ago

    Hi,

    Could you please confirm you are also using WordPress 5.5.1, the latest versions of all of your other plugins and themes, and meeting the necessary plugin requirements?

    Also, have you already ran and completed the Indexables feature under the WP admin dashboard > SEO (sidebar) > Tools > SEO Data?

    Thread Starter HireAWiz Web Design

    (@hireawiz)

    3 years, 6 months ago

    Hi Michael,

    Yes the site has been updated recently and all of the plugins are running w/ latest version and the WordPress also is running on 5.1.1 and all of the plugin requirements are met.

    And yes, I also ran the indexing using the wp yoast index command.

    Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 6 months ago

    Hi,

    This is an issue. Thank you for bringing this issue to our attention. We apologize for the trouble you are experiencing with our plugin. An issue report is currently open with our development team for this issue.

    In the meantime, we suggest signing up for our newsletter as that is where we will announce product changes and updates. You can sign-up for it here https://yoast.com/newsletter/.

    Thread Starter HireAWiz Web Design

    (@hireawiz)

    3 years, 6 months ago

    Okay. I will wait for an update on this. Thanks.

    Thread Starter HireAWiz Web Design

    (@hireawiz)

    3 years, 6 months ago

    Hi Michael,

    I saw the support ticket was marked as resolved but I did not any reply on this. Have you guys solved the issues with the queries?

    Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 6 months ago

    Hi,

    We generally set topics that are older than 7 days to resolved to keep the forum overview. Since the issue has already been identified, any bug fixes will be included in the changelog of future releases as well.

    Plugin Support devnihil

    (@devnihil)

    3 years, 6 months ago

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

    Thread Starter HireAWiz Web Design

    (@hireawiz)

    3 years, 5 months ago

    Hi Carl,

    We are still facing issues with the MySQL queries with the Yoast SEO plugin. You can see even with the latest version 15.1.1 installed, the system is running a “select *” query for all of the posts related to post type. https://d.pr/i/6Fpyc7

    We have more than 130000 posts and so the query is preventing the admin page to load.

    Do you have any update on when this will be fixed so should I remove the plugin for now?

    Thanks
    Malek

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    3 years, 5 months ago

    We are sorry to hear that you are still having trouble with the slowness issue on your website while Yoast SEO is active. We totally understand how that could be frustrating for you. Let’s see what’s going on here.

    We are currently aware of a bug where the Yoast SEO plugin causes slowness issues on a website that has bulk pages like you do. However, the database queries you are referring to here seems different. You can find the relevant bug report here https://github.com/Yoast/wordpress-seo/issues/15341 to see if the database queries match to yours.

    If the relevant database queries don’t match yours, we recommend you please submit a new bug report with all the database queries and information you have so that our development team can investigate the issue further as well.

    Plugin Support devnihil

    (@devnihil)

    3 years, 5 months ago

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘The queries running for the posts for all records vs only for the paginated ones’ is closed to new replies.