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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[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.
