Hello. Do you really need to select all these rows at once?
You can try to add ;LAZY_QUERY_EXECUTION=1 to your connection URL. Also if you use default MVStore engine such huge selects can be very slow, this problem was resolved some time ago, so if you can build database from its currents sources performance without lazy setting will be better. https://github.com/h2database/h2database http://h2database.com/html/build.html#building -- 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.
