The Sqlobject docs make it sound like a select is an iterable item.

But something as simple as:

for x in
    print x.Name

insists on getting every record (200,000) from the database before starting to print.

Shouldn't it get one record, then print the name.  Repeat 200,000 times?

I'm using postgresql, if it matters.