How to benchmark mysql databse performance using Perl DBI?

Hello all,

I'm trying out different database designs and want to benchmark their performance in terms of speed.

The only operations that matter to me are Select and Count.

How can I run a few thousand Selects and then get the time taken using a Perl script and the DBI?

Thanks