Just yesterday i made 2 slow MySQL queries perform nearly 100x faster by replacing the reckless JOINs with smart subqueries.