Hi, How large is the database exactly, and how does it grow exactly? Are you completely sure it doesn't stop growing? If yes, could you kill the process while the database is about 10 times as big as it should be, and then run the recovery tool, and post the statistics part of the the output? And then, could you shrink the file (for example by export to SQL script / import from SQL script), run recovery again, and post the statistics of this new file?
Regards, Thomas On Tue, Aug 13, 2013 at 6:27 PM, davide.cavestro <[email protected]>wrote: > I didn't measure it, but it was certainly lower. I'll give you more data > asap. > > > Noel Grandin wrote > > On Tue, Aug 13, 2013 at 5:56 PM, davide.cavestro > > < > > > davide.cavestro@ > > > > wrote: > >> I've tried replacing setCharacterStream() with setString() but the db > >> size > >> still continues to increase. Is there any way to get an idea of actual > >> fragmentation of internal data-structures? > >> > > > > Sorry, no, no idea. > > But I thought we were chasing a bug where shutdown was taking too > > long, in which case making this change should make a difference. > > Did you measure your new shutdown time with this change? > > > > -- > > 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+unsubscribe@ > > > . > > To post to this group, send email to > > > h2-database@ > > > . > > Visit this group at http://groups.google.com/group/h2-database. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- > View this message in context: > http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027132.html > Sent from the H2 Database mailing list archive at Nabble.com. > > -- > 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/groups/opt_out. > > > -- 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/groups/opt_out.
