Re: [h2] Import an embedded H2 database to an in-memory H2 database.

2015-06-16 Thread Thomas Mueller
Hi, Please see the performance section, and if you can't solve your problem, post a complete, simple, reproducible test case. Regards, Thomas On Sunday, June 14, 2015, Christian MICHON christian.mic...@gmail.com wrote: Allocate more memory to the jvm: your data is stored in the same heap

[h2] Import an embedded H2 database to an in-memory H2 database.

2015-06-14 Thread Christian MICHON
Allocate more memory to the jvm: your data is stored in the same heap space used by sql operations. Go for 1.5Gb if you're in 32 bits jvm or above 2Gb if in 64 bits jvm. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this

[h2] Import an embedded H2 database to an in-memory H2 database.

2015-06-13 Thread PaulLong
I recently began to use H2 database as storage of my data for experiments. My data is now in H2 embedded database, and now I need to import the data in the embedded database into an in-memory database. I have tried to first backup the embedded database as SQL file and then create the in-memory