I have a custom post type with 18.8k posts and custom taxonomy with 2.3k terms in Wordpress version 3.3.1. The posts have no revisions and each post has a few terms associated with it.
Loading the posts listing in admin area takes several seconds. MySQL's SHOW PROCESSLIST doesn't have any long running queries, so I assume there are many queries being run, many more than maybe necessary?
Can anyone shed some light on why the page is so slow loading and what I might be able to do to debug and/or fix it?