Re: [h2] What is the best way to persist data to disk using H2 as an embedded in-mem database?

2013-08-02 Thread Thomas Mueller
Hi, > what we would like is be able to snapshot only the incremental changes. Well, it sounds like what you really want is a persisted database with a very large cache. Did you try that? > for the same amount of data, does loading from an equivalent csv file faster than this way? There is no de

[h2] What is the best way to persist data to disk using H2 as an embedded in-mem database?

2013-08-01 Thread Jamie Wang
I have an embedded h2 database in my server application. Our application generates large number of rows. For example, some tables will have 1 to 2 million rows in a day. Our application tries to persist the data to disk periodically just in case if a server crash happens. So far we tried using