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 ?