Re: [SQLObject] Getting one item at a time in a select...

2008-07-19 Thread Oleg Broytmann
On Sat, Jul 19, 2008 at 02:52:04AM -0700, Sam's Lists wrote: > The Sqlobject docs make it sound like a select is an iterable item. > > But something as simple as: > > for x in TheTable.select(): > print x.Name > > insists on getting every record (200,000) from the database before starting >

[SQLObject] Getting one item at a time in a select...

2008-07-19 Thread Sam's Lists
The Sqlobject docs make it sound like a select is an iterable item. But something as simple as: for x in TheTable.select(): 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 ti