Lutz Steinborn wrote: > On Mon, 17 Mar 2008 14:18:31 +0900 > "masayuki.takagi" <[EMAIL PROTECTED]> 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? >> > > Hi, > > 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 > LIMIT/OFFSET.
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. Nick ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
