I believe this topic was addressed quite thoroughly here. I might add that within the WordPress community it is common syntax practice to default to echoing tags with an option or alternative/interior function to return the result instead. This I believe is driven by the level of code experience the average user within WordPress has … Read more
Your core mistake is to let users get to the admin. A proper solution is to create “admin” type of screens for your users in which there will be a more focused UX for what they can and likely to do. As part of creating it you can also optimize the experience to low power … Read more
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.