Thomas, thank you for the advice. I ran lots of tests and found out that db stops to grow if retention_time not more than 30000. Thank you very much indeed.
Regards, Sergei On Wednesday, March 18, 2015 at 8:47:16 AM UTC+2, Thomas Mueller wrote: > > Hi, > > See the documentation at > http://h2database.com/html/grammar.html#set_retention_time > > > Does this setting work when db is open? > > Yes > > > On my observations db reduces its size when closed > > It should ensure that the database file doesn't grow as large, as less old > data is kept. > > > in my case it is open all the time > > That's fine. > > Regards, > Thomas > > > On Tuesday, March 17, 2015, sim <[email protected] <javascript:>> wrote: > >> Hi Thomas, >> >> Does this setting work when db is open? On my observations db reduces >> its size when closed, >> and in my case it is open all the time. Or am I mistaken? >> >> >> On Tuesday, March 17, 2015 at 7:05:57 PM UTC+2, Thomas Mueller wrote: >>> >>> Hi, >>> >>> Yes, there is the "retention_time" setting. Did you try that already? I >>> would be interested how much this helps in your case. >>> >>> Regards, >>> Thomas >>> >>> >>> >>> >>> -- >> 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.
