I'll be more precise tomorrow, as at the moment I don't have access to the test environment.
The massive data import is the first stage a a multi-step ETL process. It collects data from an Oracle DB available on the LAN populating a local H2 db. That premised, after the first import the H2 database weights ~5gb (certainly less than 6gb), after the second it is ~7gb (hence it is not duplicated). I'm sure after some imports the db size reaches 11gb, but I don't know after how much times. Now, I want to go for both the following tasks: * prepare a smaller Oracle Db (with less data) in order to be able to execute several imports in less time (at the moment a single import takes more than 1 hour). This way I can provide you precise measurements and eventually proceed with the tests you suggested * try to reproduce the problem with a standalone test case Many thanks Davide 2013/8/13 Thomas Mueller-6 [via H2 Database] < [email protected]> > 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 <[hidden > email]<http://user/SendEmail.jtp?type=node&node=4027133&i=0> > > 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 [hidden email]<http://user/SendEmail.jtp?type=node&node=4027133&i=1> >> . >> To post to this group, send email to [hidden >> email]<http://user/SendEmail.jtp?type=node&node=4027133&i=2> >> . >> 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 [hidden email]<http://user/SendEmail.jtp?type=node&node=4027133&i=3> > . > To post to this group, send email to [hidden > email]<http://user/SendEmail.jtp?type=node&node=4027133&i=4> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027133.html > To unsubscribe from [h2] Continuous Increase in H2 db size after dropping > and loading same data repeatedly, click > here<http://h2-database.66688.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4026836&code=ZGF2aWRlLmNhdmVzdHJvQGdtYWlsLmNvbXw0MDI2ODM2fDI5MDM2MjI3NQ==> > . > NAML<http://h2-database.66688.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- 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-tp4026836p4027135.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.
