I have a wordpress blog having about 5,00,000 posts. The website works fine (I have a good server which is optimised well). But the admin panel edit.php file which lists the posts takes a lot of time to load. (more than 15seconds).I think this is because when I open http://site/wp-admin/edit.php it sorts the entire 5,00,000 posts according to date. Otherwise, everything works absolutely fine (editing posts, creating new posts everything is superfine!)
So, is there any way to speed this admin panel edit.php up? I dont want to wait 15seconds. May be if automatic sorting according to date is removed and that page lists the last 10 posts in the default order then it will become fine.
(PS. : If its a paid plugin etc, then I am willing to buy it. )