[EMAIL PROTECTED] wrote:
> mysql returns all the rows by default, if large could eat up all the memory.
> Do a perldoc DBD::mysql and look for "use_result", I forget the syntax. This
> will return the rows...here I will paste the docs,
>
>
> Note, that most attributes are valid only after a
> successfull execute. An undef value will returned in that
> case. The most important exception is the mysql_use_result
> attribute: This forces the driver to use mysql_use_result
> rather than mysql_store_result. The former is faster and
> less memory consuming, but tends to block other processes.
> (That's why mysql_store_result is the default.)
>
> To set the mysql_use_result attribute, use either of the
> following:
>
> my $sth = $dbh->prepare("QUERY", { "mysql_use_result" => 1});
>
> or
>
> my $sth = $dbh->prepare("QUERY");
> $sth->{"mysql_use_result"} = 1;
>
>
Exactly what I was looking for! You're a life saver, thank you very much.
-reid
