Good Morning. On Tue, 2021-02-23 at 05:33 -0800, Wojciech Marciniak wrote: > Don't hesitate to use H2 not only for < 100k records.
I wrote "accounts" (not records) , and each account with average 1'000 balance records and maybe 10'000 postings will give quite some data volume. I have experimented with H2 databases up to 20 GByte large and they perform surprisingly well as long as you avoid large DML with indexes or constraints. There is an open ticket on "INSERT INTO ... SELECT .. FROM ...". Best regards Andreas -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/c21193be4f101038e58e21cd2335312089453614.camel%40manticore-projects.com.
