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 <sim...@mail.ru> 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 h2-database+unsubscr...@googlegroups.com
> <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');>
> .
> To post to this group, send email to h2-database@googlegroups.com
> <javascript:_e(%7B%7D,'cvml','h2-database@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, visit https://groups.google.com/d/optout.

Reply via email to