1. Databases usually need more space than CSV. You need to use a normal file-based database (jdbc:h2:/path/to/database) instead of in-memory one.
2. Built-in CSVREAD() function in recent versions of H2 reads all data into memory too. If I remember it well, its on-disk buffering was removed due to more critical issues and it isn't yet reimplemented. -- 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/96b97ad7-f12d-4dc0-a467-7f0de400aa1a%40googlegroups.com.
