WordPress: SQL_CALC_FOUND_ROWS, why it’s slow and what to do about it?

• 

  rajinderverma · Member · May 28, 2019 at 5:33 am

  • Copy link
  • Add topic to favorites

  My site down due to MYsql query SQL_CALC_FOUND_ROWS? Help me out how to fix this issue?

  Wordpress core is not suitable for big website beacuse SQL_CALC_FOUND_ROWS & query_posts function making infinite loop (deadlock) resulting in site down?

  Mail me ((email visible only to moderators and staff)) your response to update core functions for SQL_CALC_FOUND_ROWS Mysql query.

• 

  arvindsinghu · Member · May 30, 2019 at 11:36 am

  • Copy link

  Hi @rajinderverma,

  Your site is using the self-hosted version of WordPress, and you need to seek help at the WordPress.org forums:

  https://wordpress.org/support/forums/

  These forums are for WordPress.com hosted sites only :)

  WordPress.com vs. WordPress.org

  Thanks !!!