[h2] Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present anymor

2016-07-18 Thread ck
This is my first post on this group, Hello to everyone! :) I have a problem with my H2 DATABASE. I am seriously worried by the size it is getting, it is now about 350mb (Yeah I know it's not the largest one), but my worries go all to the future and how it will scale in the long run. Issues: - T

[h2] Other way to throw away garbage of not closed transactions?

2016-07-19 Thread ck
I am facing a similar issue, can you provide all the commands needed to restore backup to decent size? Script/run script/delete all objects combo and such [+1] I am as well looking for an automatic solution to this problem instead of manually do operations in run time Thank you -- You receive

Re: [h2] Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present an

2016-07-20 Thread ck
not overwritten, > but kept. Disk space is eventually released and re-used, but that algorithm > is not yet optimized with the current version. I know this should be > improved in the future. > > Regards, > Thomas > > > > On Monday, July 18, 2016, ck > wrote: > >&

[h2] Re: Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present an

2016-07-20 Thread ck
hank you Il giorno martedì 19 luglio 2016 05:36:05 UTC+2, ck ha scritto: > > This is my first post on this group, > Hello to everyone! :) > > I have a problem with my H2 DATABASE. > I am seriously worried by the size it is getting, it is now about 350mb > (Yeah I know it'

Re: [h2] Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present an

2016-07-21 Thread ck
Sadly, the 'SHUTDOWN DEFRAG' just closes the connection pool, but the file size does not change at all. (Tried with h2 driver 1.4.185 and latest 192) The version I was using normally is: h2: 1.4.185 And before I was on 1.3 Do you think I could roll back to latest stable setting the version to 1.

Re: [h2] Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present an

2016-08-11 Thread ck
I can't by any means use an unscalable format because I want to provide a long-term working environment without being anxious it will fail sometimes I just want to clean the database, bring it to minimal size, and downgrade to 1.3 stable Can anyone help me please? I have been waiting for very lo

[h2] Column wrong when database is restored

2016-08-25 Thread ck
Hello, I recently had many troubles with my database incremening in size (10x size with MV_STORE). I found I could SCRIPT TO bak.gz and RUNSCRIPT bak.gz to an empty database to rebuild it and bring it back to actual size. Well it was good and all, after I found a bug 1 second before putting the

[h2] Column wrong when database is restored

2016-09-01 Thread ck
I hope I won't be rude upping this, but am I wrong or is this issue quite critical? Any solution? Thank you -- 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-d

Re: [h2] Column wrong when database is restored

2016-09-07 Thread ck
Hello, thanks for your help DEFAULT NOW() -> Updates when row is added to current timestamp AS NOW() -> Updates the row to current timestamp whenever the row is added/updated In my case I am storying a 'EDIT_TIME' COL, and then I need to auto update to latest timestamp all the time the row is u