in reply to speeding up mySQL query in .pm

If your run these multiple times in your program, use prepare_cached instead of prepare.

In Section Seekers of Perl Wisdom