Thanks for the quick answer but currently it's not possible to reboot my application on a regular basis because my application must ensure scheduling, failover, HA .... and it's not possible to stop it. I really need to have a solution at runtime without restarting my application. Thanks.
On 15 fév, 10:40, Noel Grandin <[email protected]> wrote: > Not sure what Thomas' plans are, > > but what I can suggest is that you set this setting to a nice large number > -Dh2.maxCompactTime=60000 > And reboot your application on a regular basis. > > See herehttp://www.h2database.com/html/grammar.html#shutdown > which sets the maximum time to compact the database on shutdown (in > milliseconds). > > On 2012-02-15 11:05, IntensiveH2 wrote: > > > > > > > > > Hi, > > > I use H2 in a commercial product and I have an issue regarding the > > size of the DB (with a customer). > > > Currently the DB size is 12 GB and after a shutdown compact/restart > > the new size is 800 MB > > When you start connection on DB (12 GB) it took around 70 minutes to > > start (on solaris) before to shutdow it with the compact option. > > This is not acceptable (from customer comment). > > > NOTE: current version used of h2 are 1.3.159, 1.3.161 and 1.3.163 (the > > result is the same for all version) > > > Do you have planned (urgently) to defragment/compact at runtime > > (similar to SHUTDOWN COMPACT) in a background thread? > > Do you have another solution to avoid this issue (long startup and > > compact at runtime)? > > > Best regards. > > Thierry. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
