Re: [SQLObject] Does SQLObject have a queryAll-like method which returns the result as generator?

On Mon, 17 Mar 2008 15:55:03 +0300, Oleg Broytmann wrote: > On Mon, Mar 17, 2008 at 03:51:47PM +0300, Oleg Broytmann wrote: >>BTW, SelectResults (i.e., the result of calling .select()) has >> .lazyIter() method that returns an iterator that inside its .next >> () method >> calls cursor.fetcho

Re: [SQLObject] Does SQLObject have a queryAll-like method which returns the result as generator?

>> 2. queryAll fetches the results by calling DB API cursor.fetchall >> (). To >> make queryAll a generator one must rewrite the method to at least >> to use >> cursor.fetchmany(). > >I will accept patches for the trunk. i have tried MySQLdb.cursors.SSCursor instead of the default Cursor

[SQLObject] Does SQLObject have a queryAll-like method which returns the result as generator?

hi all, Does SQLObject have a way to handle a result of select query as stream? My Application need to work with select queries which return 1GB~ result at once. queryAll method returns a list which contains all of the result, so it would be a cause of swapping out. Otherwise, it's too slow