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. Regards Lutz ------------------------------------------------------------------------- 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
