I'd go for option (3) myself and call

my $rowcount = $dbh->do("SELECT * FROM TABLE");
[download]

undefined behaviour (mainly coz I'd like iterators:-)

The benefit is worth the gain - and people should learn how to use COUNT().