How not to optimize a MySQL query
Response to a blog post on MySQL optimization. Has some good comments on using (or rather avoiding use of) SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED. STRAIGHT_JOIN.
read more | digg story
Response to a blog post on MySQL optimization. Has some good comments on using (or rather avoiding use of) SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED. STRAIGHT_JOIN.
read more | digg story