Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Looping through large db result sets to avoid filling memory
  • 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.
  • Done! Thanks for the quick response.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion