Re: dbi buffers results before returning?

[Tait Larson]

$sth->execute() doesn't return for a very long time (yes, the next command after $sth->execute() is $sth->fectchrow()). While I'm waiting for it to return I noticed that lots of packets are flowing from the mysqld machine to the machine running the perl process. The perl process has a huge memory footprint. I'm assuming that the perl DBD is buffering all results before returning from $sth->execute()

I think the mysql Connector/J mysql driver has support for what I'm looking for. Here's a quote from the mysql page describing Connector/J's functionality:

'The driver now also supports "streaming" result sets, which allows users to retrieve large numbers of rows without using a large memory buffer.'

I really don't want to rewrite a lot of my work in Java. Does anyone know if the mysql perl DBD has something similar to this?

Thanks,

Tait