Title: Large database, Slow performance.
Last modified: August 18, 2016

---

# Large database, Slow performance.

 *  [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/large-database-slow-performance/)
 * I have a working blog on one host (not the fastest, but ok). I tried to install(
   2.0.7)& import the posts on another host and it’s very very slow. The support
   wrote:
 * The problem is with the site itself. When you browse it call a SQL statement –
 * SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2007-01-30
    09:
   44:59′ AND (post_stat….
 * The sql statement is copying the entire wp_posts table, this table is 365MB
    
   so in effect everytime a user browses to the site it copies 365MB. This not only
   effects the performance of the website but the server aswell. I would highly 
   recommend you correct your sql statement or remove it entirely.
 * Any idea how to fix it ? make it work faster ?

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

 *  [ajd777](https://wordpress.org/support/users/ajd777/)
 * (@ajd777)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/large-database-slow-performance/#post-514257)
 * Upgrading to 2.1 may help. I don’t have a copy of 2.0.7 handy, but does it add
   a limit? If not there should be a filter for you to add it in.
 *  Thread Starter [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/large-database-slow-performance/#post-514270)
 * i don’t think upgrading will help.. It’s probably issue with any version.
 * What do you mean by limit/filter ? How can i do it ?
 *  Thread Starter [versus2](https://wordpress.org/support/users/versus2/)
 * (@versus2)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/large-database-slow-performance/#post-514507)
 * anyone ? please help..
 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/large-database-slow-performance/#post-514509)
 * > i don’t think upgrading will help.. It’s probably issue with any version.
 * I was under the impression that SQL tuning was a large part of 2.1.

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

The topic ‘Large database, Slow performance.’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [Chris_K](https://wordpress.org/support/users/handysolo/)
 * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/large-database-slow-performance/#post-514509)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics