SQL_CALC_FOUND_ROWS Help

  • I try a middle blog size with 100K post on Celeron machine. Page load takes minutes and use a lot of CPU usage. The page load a bit faster when i remove SQL_CALC_FOUND_ROWS and replace SELECT FOUND_ROWS() with with count query.

    Is there any method or MySQL configuration that make SQL_CALC_FOUND_ROWS run faster? so i can use original code.

  • The topic ‘SQL_CALC_FOUND_ROWS Help’ is closed to new replies.