sqlalchemy query all items, I wanna a generator or iterable object, not list, how to

Question

some code like below:

session.query(MODEL).all()

it will return all items with the type list

this means that, it will take a lots memory if there are a large amount items?

How can i got a iterable object, but not list.

http://stackoverflow.com/questions/7389759/memory-efficient-built-in-sqlalchemy-iterator-generator — dm03514, Dec 04 '12 at 15:20

score 0 · Answer 1 · answered Dec 04 '12 at 15:30

0

Year, not use all() , and the result is a generator

and thanks @dm03514

answered Dec 04 '12 at 15:30

Yueyoum

1 Answers1