Ing. Branislav Gerzo <[EMAIL PROTECTED]> wrote:
: Charles K. Clarkson [CKC], on Friday, November 26, 2004 at
: 04:32 (-0600) wrote these comments:
:
:
: : my $rows = $dbh->selectall_arrayref(
: : 'SELECT sessionid FROM session'
: : );
: : my $row_count = @$rows;
:
: isn't faster using SELECT COUNT(*) FROM session ?
It would be slower and less accurate. To use your
suggestion would require another query on the database.
That count might also not return the same count as is
in "scalar @$rows" if the database is updated between
queries.
HTH,
Charles K. Clarkson
--
Mobile Homes Specialist
254 968-8328
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
