Tips on how to work efficiently with SQL queries:

http://forge.mysql.com/wiki/Top10SQLPerformanceTips