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)

  • 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

    (@versus2)

    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

    (@versus2)

    anyone ? please help..

    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.