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?

link|improve this question

2  
The reason for the slow performance is a known bug which is being addressed. See the details on the bug on the WordPress Trac. As a solution if you feel comfortable working in a development environment try applying the latest patch. I'm about to do the same on a site with 40k posts! – Sneek Feb 15 at 8:47
Thanks for the info @Sneek. Do you know if this issue affects all post queries or only admin related ones? – Kevin Feb 15 at 9:33
I gave the latest version in Trac a try using the same data set, but the custom post listing still takes several seconds to load. Any other ideas? – Kevin Feb 15 at 10:41
The problem is a global problem, admin included. I am actually trying it now. Stupid inbox kept filling up! – Sneek Feb 15 at 11:10
Any updates? We ended up moving off of Wordpress for this, but I'm still interested in knowing if this was ever solved. – Kevin May 3 at 11:39
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.