RE: Shorthand for $dbh->prepare and $sth->execute?

[Steven Lembark]

> Have you ever tried selecting about a thousand or so rows?  I just wonder
> if it still would work, since the db driver really can't know how many
> rows it fetched until they are all fetched.  As I mentioned some drivers
> fetch so many rows into a cache for better efficiency, but I don't know
> how DBD::mysql does it since I rarelly use it, but I wonder if that's the
> case for you.

I have code that regularly has to select 1000's of rows from oracle --
though
I normally use fetchall_arrayref w/ prepared queries.  There are quite a few
cases where preparing queries isn't all that helpful, however (e.g., when
the
table must be chosen at runtime).  

Proably need to benchmark what the system and particular config of mysql
can handle to find out for sure...