Stuck SQL queries causing issues

  • Resolved Scott Ellison II

    (@hawkxsx)


    2 years, 9 months ago

    I updated to the latest version a few days ago, and started having issues and slowness with my site. My hosting provider provided an example SQL query that generated from this plugin:

    SELECT page, MAX(CONCAT(page, ':', DATE(created), ':', LPAD((100 - position), 3, '0'))) as uid FROM scwp_rank_math_analytics_gsc WHERE created BETWEEN '2023-04-19 00:00:00' AND '2023-05-22 23:59:59' GROUP BY page

Viewing 1 replies (of 1 total)
  • Plugin Support Rank Math Support

    (@rankmathteam)

    2 years, 9 months ago

    Hello @hawkxsx,

    Thank you for contacting the support.

    This usually happens when you have a lot of data for the Analytics module.

    Please navigate to WP Dashboard > Rank Math > General Settings > Analytics and change the number of days to save the data from 90 to 30 in the Analytics Database option.

    Once done, save the settings and then click on the Delete Data button to delete the old imported data. After that refresh the page and click on the Update Data Manually button to start a fresh data fetch with the new settings.

    Let us know how that goes. Looking forward to helping you.

Viewing 1 replies (of 1 total)

The topic ‘Stuck SQL queries causing issues’ is closed to new replies.