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 | Leave a comment

Referential Integrity – a fundamental that enables smarter and more cost effective database applications

More often than not, I find the database layer is typically a realm in applications that isn’t emphasized very much. There are certainly developers out there comfortable working with databases, but with the rise of database abstraction layers, query builders, … Continue reading

Posted in Database | 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