Thanks for pointing this out -- I missed the corresponding remark in http://www.h2database.com/html/advanced.html I had only been looking at the documentation of setFetchSize here: http://www.h2database.com/javadoc/org/h2/jdbc/JdbcStatement.html
For me this is rather bad news because while this is one concrete example, the software is written to handle arbitrary select statements (which could eg already contain limit/offset clauses, but with rather large limit numbers). To work around this with limit/offset also has the problem that there may still be a big overhead of creating too many such queries, depending on the complexity of the query while creating too few may run in the out of memory problem again. On Saturday, 5 November 2016 17:48:44 UTC, Noel Grandin wrote: > > we don't do server-side cursors yet. which is what you're asking for. > > use SELECT..LIMIT..OFFSET > > to limit the amount of data you pull in one SELECT > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
