Hi, I have surveyed a bit and found that h2 need to compact the database when the JDBC connection is closed. Hence I tried to close and reopen the connection every 1000~2000 INSERT/UPDATE. Now the size of .mv.db grows much slower, but the size is still larger than 44M, maybe I have to enlarge the shutdown delay for the DB to compact more. May tried that later.
Thanks, pishen Thomas Mueller於 2014年12月1日星期一UTC+8下午2時50分53秒寫道： > > Hi, > > It is a known problem that the .mv.db file grows large, and I'm working on > reducing the file size. However it shouldn't grow _that_ large. Could you > post your test case please? > > Regards, > Thomas > > On Sunday, November 30, 2014, pishen tsai <[email protected] <javascript:>> > wrote: > >> Hello, >> >> I'm using Anorm (in Play framework 2.3.6) to store one table with 450000 >> rows in H2 (1.4.182). >> >> The table is created by "CREATE TABLE terms (name VARCHAR(20) PRIMARY >> KEY, df INT)" >> >> After frequently INSERT and UPDATE all the data into the table, the >> .mv.db file size grows up to 20GB. >> Then, I close the JDBC connection and open it again, and the .mv.db file >> size drop back to 44MB. >> Any idea why the file size can grow and drop so much? I have checked the >> content of table, and the data seems unchanged. >> >> I'm not sure if it's the problem of transaction log, but by default, >> Anorm use JDBC with auto-commit, so each INSERT and UPDATE should be in one >> single transaction? >> >> Anorm: https://playframework.com/documentation/2.3.x/ScalaAnorm >> >> Thanks, >> pishen >> >> -- >> 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 post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
