[h2] Version 1.3.176 not on download page

Hi, I am using H2 Version 1.3.176. But I went to the download page and I no longer see it listed. Was this version removed for some reason? I would like to have the latest 1.3x, and I thought Version 1.3.176 was that version, but now that I see it is no longer online, I am wondering if it

Re: [h2] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

Sure, I will document it. Sergi 2017-07-23 16:44 GMT+03:00 Noel Grandin : > @sergi, any change you could work up some documenation for your nice new > feature? > > maybe in advanced.html and the help.csv lang reference? > ​ > > -- > You received this message because you

Re: [h2] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

@sergi, any change you could work up some documenation for your nice new feature? maybe in advanced.html and the help.csv lang reference? ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

By default H2 actively generates a result set into a separate place, then you can iterate over it. So yes, this will be slow for large tables. Lately we have introduced a new experimental setting for lazy query execution: SET LAZY_QUERY_EXECUTION TRUE; With this setting enabled result set will

Re: [h2] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

we don't support "row streaming" unless you use the rather new 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. ​ -- You received this message because you are subscribed to the Google

[h2] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

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