We have a Wordpress website that now has around 9k pages in it after an import of many location targeted pages. The frontend runs perfectly fine and there is no performance damage (after I replaced wp_list_pages with a custom MySQL query), but the Page administration section can't even be touched. All other sections of the admin open fine. Even if I navigate to a page on the frontend and use the Edit Page link, it's never able to pull up the Edit Page screen. Changing permalink structure doesn't help, which I know that was an issue with pre 3.0 wordpress. Also tried disabling all plugins, no help there. I'm running on Wordpress 3.3.2.
Halp please! My only alternative I'm thinking would be to split the website up into smaller subsites built on a Wordpress Network, but that would cause at least a month of delay of restructuring the entire website.
Someone mentioned using https://github.com/rackerhacker/MySQLTuner-perl to optimize my.cnf and MySQL. I'll have to see if this is doable on my host, if not then we'll have to move. Anyone else's thoughts would be very appreciated, thanks!
EDIT A wordpress developer mentioned that I could "turn off hierarchical display in edit.php. A filter in wp_edit_posts_query() might be able to accommodate this" as a potential workaround. Does any one have experience in dealing with something like that?