On Thu, 14 Mar 2002 22:18:11 -0500, Etienne wrote:
>Anyways, I'd like to know which method you recommend and why.. or if both
>methods are equivalent.
Easy. If you expect a large resultset, and can handle row-by-row
processing, use fetchrow, preferably a variation that returns a ref.
If you want to get everything in one swoop, and can handle the memory
requirements (i.e. a relatively small result set, compared to the memory
you can throw at it), use fetchall.
I always use fetchrow_*, but that's a habit. One approach fits all.
--
Bart.
