Monthly Archives: November 2010

Some Numbers Regarding Latency and Geolocation

This won’t uncover anything most people familiar with server latency already know:  latency increases as the distance to a given server increases.  This post isn’t much more than that, except that there are numbers and data attached to supplement that … Continue reading

Posted in Performance | Leave a comment

MySQL: Index Column Order Matters

I was recently asked about whether column order matters in composite indexes, and if so, to what extent.  I recall this being the case when working with SQL Server 2000 and 2005, so I became curious how MySQL handled scenarios … Continue reading

Posted in Database, Performance | Leave a comment

Enabling compression for faster web pages

If you’re familiar with Steve Souders, or use tools like YSlow or PageSpeed to optimize your sites, you probably already know that enabling compression for your web sites is a proven way to speed up response times. Even though that’s … Continue reading

Posted in Performance | Leave a comment