Title: SQL_CALC_FOUND_ROWS
Last modified: July 22, 2025

---

# SQL_CALC_FOUND_ROWS

 *  Resolved [omoadrodel](https://wordpress.org/support/users/omoadrodel/)
 * (@omoadrodel)
 * [11 months, 4 weeks ago](https://wordpress.org/support/topic/sql_calc_found_rows-3/)
 * We’re experiencing an issue on the live site where a query using `SQL_CALC_FOUND_ROWS`
   never finishes running. It ends up overloading the MySQL server, causing the 
   site to slow down or crash. After investigation, we found that the query is being
   generated by the Advanced Ads plugin. Could you please check this or advise us
   on how to resolve the issue? [https://app.screencast.com/uATuf1z0uBErw](https://app.screencast.com/uATuf1z0uBErw)
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsql_calc_found_rows-3%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  [henningaa](https://wordpress.org/support/users/henningaa/)
 * (@henningaa)
 * [11 months, 4 weeks ago](https://wordpress.org/support/topic/sql_calc_found_rows-3/#post-18495726)
 * Hi omoadrodel
   since your website is running and the issue may involve Advanced
   Ads Pro add-ons, I will close the thread here and continue our discussion via
   the customer support. Please note that support for paid plugins is not allowed
   here in the forum.
 * Thanks for understanding and see you there.
 * Best regards,
   Henning

Viewing 1 replies (of 1 total)

The topic ‘SQL_CALC_FOUND_ROWS’ is closed to new replies.

 * ![](https://ps.w.org/advanced-ads/assets/icon-256x256.gif?rev=2773443)
 * [Advanced Ads – Ad Manager & AdSense](https://wordpress.org/plugins/advanced-ads/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/advanced-ads/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-ads/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-ads/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-ads/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-ads/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [henningaa](https://wordpress.org/support/users/henningaa/)
 * Last activity: [11 months, 4 weeks ago](https://wordpress.org/support/topic/sql_calc_found_rows-3/#post-18495726)
 * Status: resolved