in reply to Faster way of retrieving the number of recs in mysql
my $sql = 'select count(*) from thetable';
After Compline,Zaxo