Wordpress generating slow mysql queries - is it index problem?

You can try wp-cache plugin. Also you can read this article it explains that SQL_CALC_FOUND_ROWS not the best solution at queries.

JS Bangs @antyrat Thanks for looking at this so quickly! Yes - it's an explain result (actually generated from Wp-Tuner plugin). The bit at the end is what Explain says the database is doing and the very long time it is taking to do it... – tash Mar 15 '10 at 15:37 I have WP Super Cache running - but the wp-blog-header queries are generated before the page loads, so the caching is not helping this area.

Also I'd like to fix the slowness of the Mysql query if possible, rather than cache the slow result. – tash Mar 15 '10 at 15:39 @tash how many entries do you have at your databse wt the wp_posts table? – antyrat Mar 15 '10 at 15:50 thanks for your help.

About 1,300 entries in wp-posts – tash Mar 15 '10 at 15:53 I've updated my answer, maybe you shouldn't use SQL_CALC_FOUND_ROWS at your queries? – antyrat Mar 15 '10 at 16:00.

Check this core.trac.wordpress.org/ticket/10964 The problem is SQL_CALC_NUM_ROWS, WordPress set this param automatically when you execute get_posts query, this make a slow query.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.