Lutz Steinborn wrote:
> On Mon, 17 Mar 2008 14:18:31 +0900
> "masayuki.takagi" <kamonama2@...> wrote:
>> 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 to select the result records one by one.
>> i think it would be nice if SQLObject has queryAll-like method which
>> returns the result as generator, not list.
>> Does SQLObject have such a interface?
> I can be wrong but why not use LIMIT/OFFSET and get the data in chunks? As I
> remember you don't have the complete result set in memory with
Surely doing that would be no more efficient (aside from going through
SQLObject's interface) than making multiple calls to select() yourself?
Writing a generator function to do that should be reasonably easy, though.