WordPress.org

Ready to get started?Download WordPress

Forums

Large database, Slow performance. (5 posts)

  1. versus2
    Member
    Posted 7 years ago #

    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 ?

  2. Ajd777
    Member
    Posted 7 years ago #

    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.

  3. versus2
    Member
    Posted 7 years ago #

    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 ?

  4. versus2
    Member
    Posted 7 years ago #

    anyone ? please help..

  5. Chris_K
    Member
    Posted 7 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic