I know this old (from an event back in 2006) and perhaps old-hat to the development, but thought I'd pass it along in case there are any gems: http://forge.mysql.com/wiki/Top10SQLPerformanceTips [top 84 tips in fact] Cheers, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH