Hello,

I have a website with 100k articles, and I imported them into Wordpress.

But I found it's quite slow to visit my site(hosted by wordpress 2.5).

---------+-----------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
¦ Id   ¦ Host   ¦ db         ¦ Command ¦ Time ¦ State    ¦ Info                                                 ¦
+---------+-----------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
¦ 1429797 ¦ localhost ¦ cellphone ¦ Query  ¦  0 ¦ NULL     ¦ show processlist                                           ¦
¦ 1444976 ¦ localhost ¦ cellphone ¦ Query  ¦  88 ¦ Sending data ¦ SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ¦
¦ 1444985 ¦ localhost ¦ cellphone ¦ Query  ¦  88 ¦ Sending data ¦ SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ¦
¦ 1445034 ¦ localhost ¦ cellphone ¦ Query  ¦  75 ¦ Sorting result ¦ SELECT ID, post_title, post_content FROM wp_posts WHERE post_status = 'publish' AND post_password =' ¦
¦ 1445100 ¦ localhost ¦ cellphone ¦ Query  ¦  75 ¦ Copying to tmp table ¦ SELECT ID, post_title, post_content FROM wp_posts WHERE post_status = 'publish' AND post_password =' ¦
+---------+-----------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
  

Is there any solution?

Thanks!