Title: SELECT SQL_CALC_FOUND_ROWS problem
Last modified: August 21, 2016

---

# SELECT SQL_CALC_FOUND_ROWS problem

 *  [Debugger](https://wordpress.org/support/users/retrobeatcom/)
 * (@retrobeatcom)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/select-sql_calc_found_rows-problem/)
 * Hello,
    first of all I’ll like to say that i used search on this and find a lot
   of topics here on [http://wordpress.org](http://wordpress.org) and around the
   web, but all of them are outdated and related to old WP versions.
 * So here’s my problem:
    I have a WP installation with ~210 000 posts and 1000-
   1200unique daily visits. I’m using super cache plugin but new posts are added
   every 5-6 minutes and the cache plugin is not very helpful,because it has to 
   be removed(cache) almost every minute.
 * Without the cache plugin my index page is loading around 6-7 seconds and I’ve
   noticed that the problem comes from this query:
    `Query SELECT SQL_CALC_FOUND_ROWS
   wp_posts.ID FROM wp_posts...` For the test i removed 200 000 of the posts from
   the db and then reload the index – and it was loading for 0.2-0,5s Does anyone
   know how to fix this?
 * Thanks in advance for your help!

The topic ‘SELECT SQL_CALC_FOUND_ROWS problem’ is closed to new replies.

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Debugger](https://wordpress.org/support/users/retrobeatcom/)
 * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/select-sql_calc_found_rows-problem/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics