3 Simple Patterns for Tighter MySQL Code

Join 8000 others and follow Sean Hull on twitter @hullsean. SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. Here’s a few quick tips to write tighter queries in MySQL 1. Get rid of those Subqueries! Subqueries are a standard part of SQL, unfortunately …

3 Ways to Optimize for Paging in MySQL

Join 36000 others and follow Sean Hull on twitter @hullsean. Lots and lots of web applications need to page through information. From customer records, to the albums in your itunes collection. So as web developers and architects, it’s important that we do all this efficiently. By the way, I write an article like this every …

How to Optimize MySQL UNION For High Speed

Join 38000 others and follow Sean Hull on twitter @hullsean. There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions. By the way, I write an article like this every month, covering consulting lessons, tech trends, cloud and …

A Pagerank of 5 Is Possible – Here's How

Join 4500 others and follow Sean Hull on twitter @hullsean. A highly trafficked website is a valuable asset indeed. For a services business it helps you build reputation and reach prospects. Here’s how to get there. 1. Longevity We’ve been around for a while, as you can see from a quick whois search below. I’ve …

MySQL Optimization

Experiencing performance problems with your MySQL 4.x or 5.x database? We can help. We have over a decade of experience tuning sophisticated multi-tier web applications. This allows us to identify and pinpoint problems quickly, drilldown to the relevant application and SQL, and sift out the problem code. All this makes your applications run faster, and …