On Thu, 2005-09-22 at 12:02 -0400, Jeff Ambrosino wrote:
> I'm using:
>
> DBD-mysql-2.9004
> DBI-1.47
> (and Apache::DBI)
>
> Good question about MySQL cursors... I looked through the DBD::Mysql
> docs and didn't find anything about cursors. So this means that if
> you query the whole table ("select * from ....") then you need to have
> as much RAM as the size of the table! (?!)
No. See "mysql_use_result" in the DBD::mysql docs.
Note that DBD::Oracle has a similar feature for setting the number of
rows transferred on each fetch, and that's much easier than using
cursors.
- Perrin
