2009/12/7 Sylvain Pointeau <[email protected]>: > Hi, > I did what you suggest, opening it with the shell and then "quit" to > properly close the DB. > yes it goes faster to open it after that but still it uses 8 seconds. > Is this time linear with the db size? > I put 1GB to the java process. > the other thing is that I used: > StatementUtils.execute( conn, "SHUTDOWN"); > conn.close(); > for closing the connection, > is it bad?
I simply close the JDBC connection. AFAIK H2 has a shutdown hook in the JVM to properly clean up. On my 22GB database I still only see a few seconds worth of startup? What JDBC URL are you opening the DB with? -- Cheers, Mikkel -- 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.
