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? Best regards, Sylvain On Mon, Dec 7, 2009 at 2:21 PM, Sylvain Pointeau <[email protected] > wrote: > I will try asap and let you know, > my first impression would be that I closed it normally ... but it is > probably my mistake if it work for you :-) > > Cheers, > Sylvain > > > On Mon, Dec 7, 2009 at 11:56 AM, Mikkel Kamstrup Erlandsen < > [email protected]> wrote: > >> 2009/12/7 Mikkel Kamstrup Erlandsen <[email protected]>: >> > 2009/12/7 Sylvain Pointeau <[email protected]>: >> >> Hi, >> >> I would like to know if this is normal that this is slow (15 seconds) >> to >> >> open a (large?) database (900MB)? >> >> I am using the web interface provided in the package. >> >> Best regards, >> >> Sylvain >> > >> > I have a 22GB database and it opens in a matter of seconds. How much >> > memory do you have assigned to the JVM? >> > >> > Another thing - how do you close the DB? I witnessed insanly slow >> > opening some times when the DB process had been kill -9'ed suffered an >> > OOM. There probably is some clean up going on as I can see a little >> > CPU activity and a lot of IO activity on the system while I wait for >> > H2. . What happens if you open the DB from a terminal, wait until it >> > is fully open, and then close it again. Now try re-opening from the >> > terminal. This approach has fixed for me a few times at least. >> >> I meant "... kill -9'ed _OR_ suffered an OOM" above. Sorry :-) >> >> -- >> 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]<h2-database%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> >> >> > -- 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.
