Slow Rankmath redirection query on a single product page

#467988
  • Resolved raits515
    Rank Math free

    Hi there,

    I’m using a query monitor to analyse the single product page, and there is a slow query coming from Rankmath redirection, as seen in the screenshot added to sensitive data.

    Best,

    Raido

Viewing 11 replies - 1 through 11 (of 11 total)
  • Hello,

    Thank you for contacting Rank Math support, and sorry for any inconvenience that might have been caused due to that.

    It seems our redirection checker returned 2k rows from the query which causes the slow down.

    We might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress login in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.
    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    We really look forward to helping you.

    Hi there,

    We don’t see that query error anymore, can you see it form your side? If yes I will send the login details.

    best,

    Raido

    Anas
    Rank Math business

    Hello,

    Sure, we can check that. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.
    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    We really look forward to helping you.

    Hello,

    I have updated the sensitive data as requested. Can you please check further?

    Thank you.

    Hello,

    We are still experiencing the 2k rows being queried, however, it only consumed 0.2 seconds. We also noticed your site editor keeps on freezing.

    We tried disabling the redirection module and the query is no longer there but we are still experiencing the freezing situation.

    Can you please increase your PHP Max input time to 150 or more? If you are not sure, you may ask your hosting provider to configure this for you.

    Looking forward to helping you with this one.

    HI max input time is already at 300:
    ;php_admin_value[max_input_time]=300

    Here are other server application settings:
    php_admin_value[log_errors_max_len]=0
    ;php_admin_flag[log_errors]=on
    php_admin_value[memory_limit]=256M
    php_admin_value[max_execution_time]=240
    ;php_admin_value[date.timezone]=Europe/Berlin
    ;php_admin_value[post_max_size]=25M
    ;php_admin_value[upload_max_filesize]=20M
    ;php_admin_value[max_input_vars]=3000
    ;php_admin_value[max_file_uploads]=20
    ;php_admin_value[display_errors]=off

    Hello,

    Checking the Site Info on your WordPress website, the Max input time is still set to 120 as you can see in my screenshot below:

    site info

    Can you please confirm on your end?

    With that said, our redirection which is querying 2k rows doesn’t add much time load as we check the query monitor and after disabling our redirection module, the slow issue of your website is still there.

    Can you please try to conduct a troubleshooting issue to see if there are other plugins or your currently active theme that might be causing it? You may follow this guide: https://rankmath.com/kb/check-plugin-conflicts/

    Only the site admin would know and your users won’t be affected by this troubleshooting.

    Looking forward to helping you with this one.

    Hi,

    I contacted hosting our provider and it should be now 300

    best,

    Raido

    Hello,

    Please note that when you have so many redirections you should consider putting them on the server configuration file which should yield much more performance.

    That’s because our plugin needs to go through all the redirections with a particular pattern to encounter the one that matches this page if there’s one.

    When you pass the 500 mark in the redirections module we recommend opting for the server configuration file for performance issues.

    Don’t hesitate to get in touch if you have any other questions.

    Hi do you have any guide how to do that?

    Best,
    Raido

    Hello,

    You may upgrade your server which should help you process those large redirection queries. You may check this one with your hosting provider.

    Looking forward to helping you with this one.

    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 11 replies - 1 through 11 (of 11 total)

The ticket ‘Slow Rankmath redirection query on a single product page’ is closed to new replies.