Hi, Could you try again with the latest version of H2?
(Please not there is a bug that prevents index usage if you use auto-increment column; but I think you don't use this, so it shouldn't affect you). Regards, Thomas On Mon, Dec 1, 2014 at 12:18 PM, pishen tsai <[email protected]> wrote: > 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]> 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. > -- 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.
