My site has over 50,000 posts and the overall database size is just over 300mb, with wp_posts being over 100mb
Have I out-grown wordpress?
I have hypercache installed and running.
I have checked the plugins,removed ones I don't need and using wptuner have found the query slowing things down is:
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') AND wp_posts.ID NOT IN ....ORDER BY wp_posts.post_date DESC LIMIT 0, 15
which is located in: [wp-blog-header.php(14): wp()]