Title: Many posts
Last modified: August 19, 2016

---

# Many posts

 *  [lorenzov](https://wordpress.org/support/users/lorenzov/)
 * (@lorenzov)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/many-posts/)
 * I have an installation of Wp 2.8.4 with 20.000+ posts.
    SQL queries are getting
   slow, **do you have any hints for optimization?**
 * Looking at mysql slow queries log I see a lot of sql commands that are taking
   many seconds to execute, here a few ones:
 * SELECT SQL_CALC_FOUND_ROWS wp_sport_posts.* FROM wp_sport_posts WHERE 1=1 AND
   wp_sport_posts.post_type = ‘post’ AND (wp_sport_posts.post_status = ‘publish’)
   ORDER BY wp_sport_posts.post_date DESC LIMIT 0, 10;
 * SELECT SQL_CALC_FOUND_ROWS wp_sport_posts.* FROM wp_sport_posts WHERE 1=1 AND
   wp_sport_posts.post_type = ‘post’ AND (wp_sport_posts.post_status = ‘publish’)
   ORDER BY wp_sport_posts.ID ASC LIMIT 0, 1;

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/many-posts/#post-1263295)
 * Well I can at least point you to some recent trac discussions on this:
 * [http://core.trac.wordpress.org/ticket/10964](http://core.trac.wordpress.org/ticket/10964)
   
   [http://core.trac.wordpress.org/ticket/10469](http://core.trac.wordpress.org/ticket/10469)
 *  Thread Starter [lorenzov](https://wordpress.org/support/users/lorenzov/)
 * (@lorenzov)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/many-posts/#post-1263402)
 * thanks it helped a lot, but some queries are still slowing down the installation.
   
   Is anyone still working on optimizing those queries? I think lots of sites are
   experiencing the same issues and there’s space for further improvements
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/many-posts/#post-1263486)
 * Since both of those trac tickets are still open you might consider commenting
   on one or both about your experiences. Use your forum login/password at trac.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Many posts’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [16 years, 7 months ago](https://wordpress.org/support/topic/many-posts/#post-1263486)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics