Put simply: not inherently. If you have a widget that does NOTHING at all…like, literally you add it and there’s no code for the widget outside of registering it, you’ll see SUCH a small performance hit from adding it that you would need to be looking at microtime() numbers to notice anything. That said, as … Read more
Go to wp-config.php, find the line below: define(‘DB_HOST’, ‘localhost:8889’); And change it to: define(‘DB_HOST’, ‘127.0.0.1:8889’); Works like a charm!
2,000,000,000,000 WordPress posts, is it possible? Simple answer, Yes. The days of 2GB size limit on file systems are gone. Now, you can literally have unlimited entries on almost everywhere if your hardware can support it. So I’m gonna change the question into this: 2,000,000 WordPress posts, Should I have it? To decide whether WordPress … Read more
I recommend you to read this article W3 Total Cache -Plugin: The Complete Settings Guide, it’s a great tutorial to manually setup your w3tc. And when you saving your settings remember to flush your cache because if you don’t Google Pagespeed will test it on the old cached files.. You can try to add this … Read more
Nginx is really good at concurrency (PHP not so much) so you should try a bit more than 180 requests per second. Maybe 500, or 1000 depending on your server resources and network throughput. The fastcgi_cache is served directly from ram. Wp-super-cache uses php to read a static file from the SSD so I see … Read more
If INT is set to UNSIGNED, allowing only non-negative integers, your value range is from 0 to 4294967295. Thats… 4,294,967,295 (4 billion +). …for the given table. Just to put things into perspective. Only through poor management and unnecessary incrementation would you exhaust that range, say for your posts table as an example. That said … Read more
It’s really simply GoDaddy and slow mysql and webservers. I’ve heard apocryphal stories of people making lots of noise to GoDaddy support and as a result, speeds improve. Do they get moved to better servers or get priority load-balancing? Impossible to say. One other thing to try is http://wordpress.org/extend/plugins/use-google-libraries/ but sometimes it doesn’t help much … Read more
It sounds like you’re already on the right track, adding additional indexes and tweaking the query. I’ve found MySQL’s EXPLAIN syntax to be helpful, giving me a good sense of where in the query things might be going awry. From a high-level, it appears that the query has a lot of joined tables, LIKE comparisons … Read more
Try using this plugin http://wordpress.org/extend/plugins/debug-queries/ for checking performance of your database queries. It shows lots of detatils about each and every query made and time the query needed to complete and the time needed to make the whole page.