[h2] the database grows

2019-07-17 Thread Patrice
In a database managed via H2 (version 1.4.199), any request of the type "select" seems to increase the size of the base (8 KO each time) which I can possibly understand to keep a trace of the transactions. Is there a way however to return to the original size if we did not change anything in

Re: [h2] Re: Database Grows Rapidly

2015-06-22 Thread bryan
Yes, that was my conclusion in the original post. However, I could not find any uncommitted transactions. My database creation test is right up above. If my test has a bug, then perhaps someone can spot it. Thanks! On Saturday, June 20, 2015 at 6:17:59 AM UTC-7, Noel Grandin wrote: On Fri,

[h2] Re: Database Grows Rapidly

2015-06-19 Thread bryan
Hi, thanks for the reply. I'm not sure it is related to the TEXT/CLOB column. In my tests I have used TEXT,CLOB, and VARCHAR with small sizes (64 bytes each) and larger sizes (1MB each). All tests have shown the same increase in size. MV_STORE=false did not seem to change this. Although, I