Hi Thomas, Great! Glad I could help make your superb product even better.
On Friday, 18 April 2014 21:38:27 UTC+2, Thomas Mueller wrote: > > 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]<javascript:> > > 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] <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.
