in reply to Faster way of retrieving the number of recs in mysql

my $sql = 'select count(*) from thetable';

After Compline,
Zaxo