> > my $sql = 'SELECT COUNT(*) FROM temp';
> yes - but this will result in a additional select and therefor more database
> activity :-(
Not a huge cost if it's against an index....
> > my $i = 0;
> > while (my @row = $sth->fetchrow_array()) {
> > $i++;
> > }
> very difficult in my code... i will have a look if i can change the code.
> isn't it possible without a "while" ?
How did you plan on *retrieving* the data if not through a loop? If you
plan on actually getting all the data, you'll have to loop through all the
rows I think. Maybe you could post a code fragment?
