Feature request: add streaming mode [moved] #10
Description
This is Issue 10 moved from a Google Code project.
Added by 2012-08-03T15:01:57.000Z by julian.morrison.
Please review that bug for more context and additional comments, but update this bug.
Original labels: Type-Enhancement, Priority-Medium, OpSys-All
Original description
Please add the ability to use streaming mode, like this http://dev.mysql.com/doc/refman/5.0/en/mysql-use-result.html so that rows.Next() actually fetches the next row, rather than slicing an in-memory list of rows.
The company I work for has a use case where we want to read very large result sets that would be too large to fit in memory at once. (Right now we can do that by fetching the Id column only, and then reading blocks of results with new queries, but that's inefficient.)
Probably, this should be a parameter in the DSN.