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]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
