Hi Thomas, I tested the same large data import with H2 1.4.178, and there is no improvement over H2 1.4.177.
Here are the file sizes, in both cases after the app has stopped: H2 1.3.176: pokercopilot.h2.db 301,669,352 bytes H2 1.4.178: pokercopilot.mv.db 1,023,037,440 bytes Let me know what I can do to help. Regards, Steve On Saturday, 19 April 2014 11:44:05 UTC+2, Steve McLeod wrote: > > 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]>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.
