in reply to How to improve MYSQL search performance of perl?
There is great online MySQL documentation available at http://dev.mysql.com/doc/, specifically a chapter on optimizing queries at http://dev.mysql.com/doc/mysql/en/query-speed.html.
In Section
Seekers of Perl Wisdom