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.
