100,000 articles in Wordpress?

[bryanw]

Hello,

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

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

Is there any solution?

Thanks!

[Germz]

Maybe it's because it's 100k articles! wow that's amazing!

[bryanw]

Thanks for your reply.

When showprocesslist, wp was executing the following commands,
Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |

The page stopped loading.

[pixeladd]

yeh thats alot of articles