Catching up on RSS feeds this morning I was extremely interested to see this technique for speeding up GROUP BY queries using approximation. In the first example, it knocked down the processing time from over 30 minutes to 30 seconds pretty much (as far as I can make out) because of MySQL’s speed in string comparison operations.

I can see this would be really useful for search tables…