We are still working on the issues with slow pages loading here and I apologize to readers who visit this blog and experience a page loading delay. I’ve spent a lot of time on this (more than I wanted to, for sure), but I’m not giving up until the page loads almost as fast or as fast as it did before we switched to Wordpress (which might be too lofty an expectation, we’ll see). If this means that I need to rewrite and/or optimize some queries inside Wordpress then I am planning to do so.

I’ve already removed queries that we don’t need to be dynamic like the archives and category and traced the remaining issues down to some suspect MySQL queries — a table join in particular inside Wordpress 1.5 that is showing up frequently in the mysql-slow.log

I wonder how many others who have more than 1,500 posts and 800+ comments have had to deal with this issue?

The Wordpress support area has a couple somewhat older threads about this, but there’s not really any definitive solution that I’ve found yet. I wonder if Matt has any ideas?