There are some more tips to optimize large queries here-
http://www.debianadmin.com/top-84-my...ance-tips.html
http://www.debuntu.org/2006/07/21/75...-response-time