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. -- 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.
