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
>
> > 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 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 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 h2-database...@googlegroups.com.
>> To post to this group, send email to h2-da...@googlegroups.com.
>>
>> 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 h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
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 h2-database...@googlegroups.com .
>> To post to this group, send email to h2-da...@googlegroups.com
>> .
>> 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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, vi