I have about 4,000 posts. Currently when I click on All Posts (edit.php) it's taking about 10 seconds to load and I'm showing approximately 1000 queries!
Most of them look like...
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (37336) ORDER BY t.name ASC
If I deactivate Wordpress SEO, I can cut the number of queries in half but the page still takes approximately 7 seconds to load.
Just for fun, I deactivated all my plugins to no significant performance improvement. I've tweaked MySQL and PHP in about every way I can think of. The issue is the exorbitant amount of queries.
Any way to tweak Wordpress here to use less? I have tried deleting revisions, etc. Nada. Really could use some insight here.