Delete post/page revisions and that will reduce queries as well as the overall size of the DB. Run this in phpmyadmin (backup the DB first): DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type=”revision” Change table prefix above if needed. And … Read more
195 queries for one page is a lot. 7000 queries is not a lot, it is insane. Install Query Monitor. It tracks all queries and presents them in groups. I don’t know if it can track that many queries, this is probably an interesting stress test. 🙂 Find the source of those queries, deactivate it. … Read more
Turns out the guy didn’t have his auto-rotate on. I apologise for the pointless question.
Yes, it is good, but other options are also good. There is no silver bullet in term of webservers and caching software, if there was everybody would have been using the same tools. It depends both on what are your actual needs and how comfortable are you with managing the tools. For example it might … Read more
Solved by editing site url at wp_site and wp_options tables in database.
Maybe your PHP is running per CGI or FastCGI in a separate process that shuts down after a while of inactivity. Does it change if you register at an uptime monitoring service? A cache plugin like W3 Total Cache may help too.
First of all – “good” is a bit vague a term.. Good for what ?? IF you mean technically valid , there are SOOOO many items to check, that you can fill a whole website with it . Those items also depend on personal preferences and are not always objective AND are changing with time … Read more
I did a lot of digging into wordpress, and it looks like WP_Query ends up calling (indirectly) update_postmeta_cache($postIDs); which looks like it is exactly what I need. Hope that helps somebody else out. In 3.5.1 it’s located in wp-includes/post.php#2735.
Did you check your hosting environment to see if they’ve enabled something like mod_pagespeed? https://developers.google.com/speed/pagespeed/mod
admin.php taking 14 seconds