Rank Math Admin Slow Queries in Product Tags

#597910
  • Resolved Vivek
    Rank Math free

    Hi Team,

    Greetings!

    I have recently noticed, in the WordPress admin panel for all pages rank math calls product_tag taxonomy. The query monitor detects a slow query because it returns all the rows in the table. in my case, it returns more than 125000 every time on all pages.

    How can I improve this by adding a limit/cache?

    See the attachment for your reference.

    Rank math slow query log

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Vivek
    Rank Math free

    Hello,

    Thank you for contacting Rank Math and bringing your concern to our attention. I’m sorry for any inconvenience this issue may have caused you.

    It seems that you have a lot of taxonomies on your website, and since our plugin attaches itself to those pages to provide SEO, it might be causing the resource limits of the server to be reached.

    We have this functionality running on an optimized SQL query already to reduce the server overhead, but when you have literally what looks like thousands of taxonomies, the limitation becomes essentially the server resources which are not capable of handling all the queries.

    In this case, our recommendations for server variables for a medium website are the following:

    PHP Memory Limit: 512M
    Max input time: 150
    PHP time limit: 120
    PHP max input variables: 1000

    Hope that helps.

    Thank you.

    Vivek
    Rank Math free

    Hi Reinelle,

    I already have recommended the server resources setting.

    Is there any way to limit the taxonomies query to fetch fewer records like 100 or 1000?

    We need to limit by pagination kind of this thing.

    Thank you.

    Hello,

    The only way around this would be to increase the server resources to a point where trying to load all the taxonomies associated with posts would be a much quicker SQL query.

    Our developers are always looking into ways to improve the SQL queries so that they are fast enough to run on most websites, but when you have so many elements the bottleneck will always be the server usage.

    However, if there’s anything that we can do in the future to improve the speed of this module, we’ll surely make the necessary changes and inform all our users via the usual communication channels.

    You can also keep an eye on our changelog here:
    https://rankmath.com/changelog/

    Looking forward to helping you.

    Thank you.

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

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

The ticket ‘Rank Math Admin Slow Queries in Product Tags’ is closed to new replies.