Hi, How long is the startup about, in seconds? A long startup time could mean there is a long running transaction (not sure).
I guess creating a reproducible test case isn't easy, but could you send me a database file of an unclosed database file? Just use your application for a few minutes (the longer the better, the more active use the better), wait a few seconds, and copy the database file while the database is open. There might be some clue in the transaction log. In the database file you sent, the transaction log was empty, which is normal after opening the database. Regards, Thomas On Tuesday, April 23, 2013, Noel Grandin wrote: > > On 2013-04-23 05:46, TrendTimer.com wrote: > >> >> >> So have you spent much time looking into the H2 startup time? When I >> launch my application about half the startup time is getting H2 started. >> It's not terrible, but perhaps you could figure out ways to improve this. >> :) >> > > There are a couple of things you can try here: > (*) run SHUTDOWN COMPACT to compact the data, which will reduce the amount > of IO > (*) start H2 up in parallel with the rest of your application, using a > separate thread > (*) run a profiler and show us the trace so we can see where it's slow in > your use case (it's pretty fast for me) > > -- > 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?hl=en<http://groups.google.com/group/h2-database?hl=en> > . > For more options, visit > https://groups.google.com/**groups/opt_out<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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
