LAZY_QUERY_EXECUTION feature (add ";LAZY_QUERY_EXECUTION=1") to your URL.
In general, trying to retrieve 10 million rows in one result set is not good idea.
The problem is that when i query "SELECT * FROM test" with a table of 10 million rows, it takes like 20 seconds and then it returns the ResultSet, but when in sqlite i make the same query, it returns the ResultSet immediately and it seems to stream the rows, but H2 doesn't seem to stream the rowsl, is it me doing something wrong ?
--
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 h2-database+unsubscribe@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
@sergi, any change you could work up some documenation for your nice new feature?maybe in advanced.html and the help.csv lang reference?
--