I use WP to run a news site. The site grew extensively last couple of week and now the posts table has almost 500,000 posts. Problem is now the admin shows the correct number of pages (497,427), but when I click on pages to view/manage the pages, it just dies out.
I have had this problem with other sites as well in which as the number of posts in a category grew, it stopped showing any posts in that category in the userside and the admin side.
IMO, its not WP issue, but the server issue, but what do I need to do to solve this problem?