Title: SQL_CALC_FOUND_ROWS Help
Last modified: August 18, 2016

---

# SQL_CALC_FOUND_ROWS Help

 *  [chalee1](https://wordpress.org/support/users/chalee1/)
 * (@chalee1)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/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.

## Tags

 * [Large Database](https://wordpress.org/support/topic-tag/large-database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [chalee1](https://wordpress.org/support/users/chalee1/)
 * Last activity: [18 years, 10 months ago](https://wordpress.org/support/topic/sql_calc_found_rows-help/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics