I can’t personally help you, but I will tell you that it’s a good idea to post the job on the WordPress Job board. Lots of WP experts look around there! 🙂
I posted on the WP job board per the suggestion, but they haven’t even displayed my job posting yet, and it’s been a couple days.
Anyone out there interested?
Thanks!
I’d instll WP Super Cache http://wordpress.org/extend/plugins/wp-super-cache/
It should cache your pages and reduce the SQL load significantly.
It’s already installed. 🙁 It doesn’t seem to be helping.
Although, WP Super Cache does give me this warning:
It appears that mod_rewrite is not installed. Sometimes this check isn’t 100% reliable, especially if you are not using Apache. Please verify that the mod_rewrite module is loaded. It is required for serving Super Cache static files. You will still be able to use WP-Cache.
I asked my host and they say mod_rewrite is, in fact, installed.
Hmmmmm ….
Any other tips on reducing SQL load?
Any other tips on reducing SQL load?
Other than disabling functions which your not using, Increasing the cache timeout, and potentially enabling a Persistant Object Cache, theres very little you can do aside from move to a better server.
WordPress can handle a high load if given the resources it needs.. But i’m no good at optimization 🙂
Okay …
I hard-coded a bunch of stuff in my header.php, footer.php and sidebar.php. I didn’t realize how often WP is querying the database for info that can pretty much be hard-coded. I guess the point is to have a really flexible solution, which works great for most bloggers, but it trades off on efficiency, which gets to be a real problem when you’re seeing over 500K page views daily.
I also disabled pretty much all the plugins except for WP Super Cache, Pagebar and WP-phpMyAdmin.
Hopefully this will make some difference tomorrow during the peak times.
Also: I have quite a few pages where the comment count is well over 2000. They’re popular pages, and I think they’re slowing down the server considerably. I hate to do this to readers, but I may just have to bite the bullet and delete all those comments. Any other thoughts on the comment issue?
Thanks again to everyone for their help!