Can CI's database class do this? (Memory Issues w/large data sets)

[eluser]Sarfaraz Soomro[/eluser]

Basically I need CI to not create an array of all the results initially.

First thought, you might want to run the query in a loop with limit set to 1 and offset incrementing, not a good approach IMO, maybe some one with more experience in this regard may enlighten us.