good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re: Sqlite DBI $sth->rowsby b10m (Vicar) |
on Oct 22, 2003 at 17:30 UTC ( [id://301291]=note: print w/replies, xml ) | Need Help?? |
I fully agree. I had the same problems and scanned the web quite extensively. The SELECT COUNT method seems to work best (well, at least for me :) I'd prefer it over fetching all rows and counting them in a while loop, since that seems like a waste of resources to me (especially on really large data sets), and also over the $sth->rows, 'cause that doesn't seem to be reliable on SELECT queries.
--
In Section
Seekers of Perl Wisdom
|
|