Website is slow: advice on optimization

If possible get your PHP updated to the 5.4.x branch. Before you add your caching layer you need to determine whats slowing down MySql and PHP. You need to enable WP_Debug and eliminate any PHP errors. Look for undefined indexes, syntax errors and deprecated functions. That 20 second to first byte is all PHP, MySql … Read more

Where should I host my images?

I’m probably overcomplicating things. Right now, you are. As I have no traffic as of now I don’t really need to do this, but …. I don’t know what to choose as I don’t understand what these services really do, other than it’s supposed to be “better” to host externally… Then why bother with a … Read more

Optimize Multiple Taxonomy Term MySQL Query?

While this is really a MySQL question it does help to understand the WordPress SQL schema and also I love trying to optimize SQL queries so rather than send you off to StackOverflow I’ll try to answer you here. You may still want to post it over there to get some other opinions. And while … Read more

What’s the case against transient-ing almost everything that’s mostly static?

Actually, doing it for menu is good, you can even store entire HTML output and cut not only queries, but processing time too. Additionally, you can use WP_Object_Cache directly in conjunction with Redis/Memcached backend and avoid even single DB query for the transient itself. Re comments – they do change, so running WP_Comment_Query is unavoidable. … Read more

Safe to disable wptexturize?

wptexturize() (in wp-includes/formatting.php) tries to convert typewriter quotes ” and ‘ into typographically correct pendants like “ or «, depending on current translation files. If you cannot type correct quotes, you should not disable it. There are some related replacements for dashes and ellipsis (not localized for whatever reason). All these replacement are done with … Read more

Scaling a WP eCommerce site

I’ve developed a 55k product ecommerce site using WordPress with the Shopp plugin and can share what I’ve done to MySQL to eke out better performance, YMMV and some (or all) of these may not apply to your situation. Determine how much you need to increase buffers/caches by by looking at the output from a … Read more

Long Waiting Times on GoDaddy? [closed]

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

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)