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