Hi Thomas, Thanks for the suggestion. I tried adding ";retention_time=1000" to the URL, and this resulted in a small improvement.
pokercopilot.h2.db 302,018,560 bytes pokercopilot.mv.db 999,120,896 bytes pokercopilot.mv.db with RETENTION_TIME=1000: 811,728,896 bytes These numbers all reflect a loading of data in a newly created database that consisted of roughly 2,400,000 INSERTS and UPDATES with plenty of SELECTS and almost no DELETES. After the loading was complete, I let the application keep running with the database open for a few minutes, then close the application and therefore the database. Here is the full JDBC url I'm using: jdbc:h2:/Users/steve/Library/Application Support/com.barbarysoftware.pokercopilot/database/pokercopilot;DATABASE_EVENT_LISTENER='com.barbarysoftware.pokercopilot.database.DatabaseListener';COMPRESS_LOB=DEFLATE;CACHE_SIZE=65536;RETENTION_TIME=1000 Let me know if there is anything else I can do to help diagnose this. Regards, Steve On Thursday, 17 April 2014 17:15:50 UTC+2, Thomas Mueller wrote: > > Hi, > > Probably it's due to the long default retention time, see > http://h2database.com/html/grammar.html#set_retention_time - try adding > ";retention_time=1000" > to the database URL, and tell us if and how much this reduced the size. > > Regards, > Thomas > > > > On Thu, Apr 17, 2014 at 3:51 PM, Steve McLeod > <[email protected]<javascript:> > > wrote: > >> Hi Thomas, >> >> I've tried my desktop app with the new MV store in 1.4.177. After loading >> a significant amount of data, the database file is 3 times the size, >> compared to H2 1.3.176 >> >> Here are the file sizes, in both cases after the app has stopped: >> >> pokercopilot.h2.db 302,018,560 bytes >> pokercopilot.mv.db 999,120,896 bytes >> >> Is that expected? If not, what can I do to help locate the problem? >> >> >> Regards, >> >> Steve >> >> >> -- >> 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:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
