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 wrote: > Allocate more memory to the jvm: your data is stored in the same heap > space used by sql operat

[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 g

[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