Hi, Thanks a lot for the database! I know what the problem is now, but I couldn't fix it yet. The database file (pokercopilot2.mv.db) has about 181 MB of "live" data, the rest (about 78%) is not used. The mechanism to get rid of the unused space is not working as it should for this case (I think the problem is that b-tree nodes are not processed correctly). This will be fixed in the next release.
Regards, Thomas On Fri, Apr 18, 2014 at 5:29 PM, Steve McLeod <[email protected]>wrote: > Hi Thomas, > > I've sent a link to file privately to your email address. > > Regards, > > Steve > > > > On Friday, 18 April 2014 14:04:37 UTC+2, Thomas Mueller wrote: > >> Hi, >> >> Hm, that didn't help much. Could you send me the (compressed) database >> files please? If it's too big, what is the compressed size of the files? >> >> Regards, >> Thomas >> >> >> On Fri, Apr 18, 2014 at 1:07 PM, Steve McLeod <[email protected]>wrote: >> >>> 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]>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]. >>>>> 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. > -- 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.
