Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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.

Thanks!

share|improve this question
    
How many posts per page are you showing? By default it is something like 20-30. Have you changed that? (Its a screen option.) –  s_ha_dum Dec 29 '12 at 17:14
    
It was set at 200 by our editor who was complaining. I feel a little embarrassed now that I failed to check that. It's still too many queries for 20 records (which I set it to right now.) but at least it's not 10 seconds (for me.) She was reporting 30 seconds :) –  Bretticus Jan 2 '13 at 18:12
1  
Even though the issue is moot on long times now, does anyone know how to make each page load a little less query intensive? –  Bretticus Jan 2 '13 at 18:15
    
I'm curious as well. Anyone? Facing the exact same thing, only our server config dies and throws memory errors (despite upgrading the server's RAM already). With it restricted to a small number of posts, we're fine, but anything above 10-20 kills the script and won't show anything. –  Will Ashworth Jan 8 '13 at 6:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.