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

Reply via email to