[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
: Charles K. Clarkson [CKC], on Saturday, November 27, 2004 at
: 10:21 (-0600) thinks about:
:
: : Here's the method you presented.
: : my $rows = $dbh->selectall_arrayref(
: : 'SELECT sessionid FROM session'
: : );
:
Charles K. Clarkson [CKC], on Saturday, November 27, 2004 at 10:21
(-0600) thinks about:
CKC> Here's the method you presented.
CKC> my $rows = $dbh->>selectall_arrayref(
CKC> 'SELECT sessionid FROM session'
CKC> );
CKC> my $row_count = $dbh->do(
CKC>
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
: Charles K. Clarkson [CKC], on Friday, November 26, 2004 at
: 05:30 (-0600) has on mind:
:
: : 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
Ing. Branislav Gerzo [IBG], on Saturday, November 27, 2004 at 15:20
(+0100) has on mind:
as I see, I should use better benchmarking:
http://uk.builder.com/webdevelopment/scripting/0,39026636,39220598-2,00.htm
but that not changes my conclusion :)
--
...m8s, cu l8r, Brano.
[I tawt I taw a B
Charles K. Clarkson [CKC], on Friday, November 26, 2004 at 05:30
(-0600) has on mind:
CKC> It would be slower and less accurate. To use your
CKC> suggestion would require another query on the database.
CKC> That count might also not return the same count as is
CKC> in "scalar @$rows" if the da
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;
:
:
Charles K. Clarkson [CKC], on Friday, November 26, 2004 at 04:32
(-0600) wrote these comments:
CKC>my $rows = $dbh->>selectall_arrayref(
CKC> 'SELECT sessionid FROM session'
CKC> );
CKC> my $row_count = @$rows;
isn't faster using SELECT COUNT(*) FROM session ?
--
Anish Kumar K. <[EMAIL PROTECTED]> wrote:
: $rows=$dbh->selectall_arrayref("SELECT sessionid FROM session");
:
: I want to get the count...For example if it returns
: three rowsThen count should be three...
:
: How will I get the countAs soon after I want to
: print the count in the star
