Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,

I want to find the quickest possible way to count the number of rows in a mysql db.

Heres part of my code that returns this "ARRAY(0x1ae8674)"
my $sqlc = "SELECT COUNT(*) FROM company_info"; my $crows= $dbh->selectrow_arrayref($sqlc); print $crows; #I did not use prepare or execute since I heard selectrow_arrayref wra +ps it around
I also tried using print $crows[0], but then it says it requires global symbol @crows.

What am I doing wrong?

Since this code and sql statement will only generate 1 row returned with 1 column--would selectcol_arrayref be better then selectrow_arrayref ?