IMHO that would depend on the hosting company and what resources you are limited to. Let’s say you pick Amazon’s MySQL RDS. There are seven server models permitted. Each model allows a maximum value for the number of connections. I wrote a post about this last month in the DBA StackExchanage : Should I increase … Read more
I will try to answer this as best as possible given that there is no bulletproof method. It’s up to the developer to really plan out how the DOM is painted, WordPress cannot guess as to what a theme/plugin/user is going to be doing, it can simply provide some guidance and basic tools. The problem … Read more
After more fruitless searching, I stumbled across this article from WP Tavern which mentioned a plugin then called “WP Local Dev Environment,” now called Airplane Mode. The plugin blocks a long list of things that WordPress does which require checking something from the Internet. While it is intended to be toggled on or off depending … Read more
This is not a very smart thing to do. As you noted yourself, you’ll have issues when the parent theme is updated. Moreover, the parent theme might have secondary stylesheets that depend on the parent style (third parameter in wp_enqueue_style). There might be javascript that assumes it’s there. In other words: it will take very … Read more
All options are loaded at pageload, because they include not only plugin/theme options, but also WP native stuff, like menus and widgets. Distinguishing between which ones to (not) load based on whether they are needed would take quite some calculations, so the performance issue you refer to doesn’t exist. Now about the extensibility. Let’s take … Read more
Well, WordPress.com is a single installation of WordPress multisite (one extremely well optimized, cached, and load balanced installation, but still just one). I just checked, and they run over 19 million blogs there, with better performance than any site I’ve ever built. Obviously, your server(s) and environments will need to grow with your site. I … Read more
I have a solution, but it’s a really ugly one. I’d love to hear a better one, but I’m not sure it’s possible. WP_Query::get_posts() calls parse_tax_query() twice: first near the start, then again just before getting the SQL from it. There’s no single hook that lets me intercept and adjust the value of $tax_query in … Read more
If you’ve got 60,000 records, try cleaning post/page revisions; these really accumulate and cause excessively long queries. I’ve seen database sizes drop 90% with huge increases in performance. Run the query below in phpmyadmin or from the command line and then optimize: DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) … Read more
If you look at the source for the home_url() function, you’ll note a small series of function calls eventually invoking get_option(). As explained in this WPSE Answer, the get_option() function is cached, meaning that if an option’s value is already in memory, get_option() returns that value instead of querying the database again. As a result, … Read more
There are a lot of tools available Below are my personal favourites Pingdom http://tools.pingdom.com/fpt Google Pagespeed https://developers.google.com/speed/pagespeed/insights GTMetrix gtmetrix.com