[h2] Re: Size of h2 .db file keeps growing

2017-08-14 Thread liliang4gz
My solution is importing data to h2 normally, and the *mv.db file size increased dramatically, and then jdbc/execute! a sql to create a empty table with db url option ";DEFRAG_ALWAYS=TRUE", the size of db file dropped dramatically. the reason to do this is if jdbc/insert-multi! with

[h2] Re: Size of h2 .db file keeps growing

2017-08-13 Thread liliang4gz
I had met a same problem, and could not resolve it. I just import data into H2 (embeded mode) through jdbc in first time, and following I will only execute jdbc query, but the *.mv.db file size auto increased dramatically, from about 600M to 1.8G, if query without "union all", the db file