Are there plans to include a fetch() -type function in the DB class rather than fetchAll()?
I have a large table that I need to process a record at a time and using the current DB class blows out my memory limit on execute().
I was thinking of extending the DB and PDO classes to add an execute_only() and fetch() function or something along those lines, so that I can loop through the records fetching one at a time rather than try (and fail) to read the whole table into memory.
Any thoughts?
Please add a feature request for this at http://github.com/fuel/core/issues.
We're going to redesign the database functionality for the next version, we can see if this will fit in.