Hi, You wrote you use a SSD HD, what kind? What operating system and file system do you use (it looks like Mac OS, just to be sure)?
According to the stack trace, most of the time (80%) is spent _closing_ the database file. That's really strange. Probably it is related to the SSD. Another 15% is spent writing empty pages. I wonder how many empty pages are in your database... In theory, it should be 0 if closed normally (unless you have deleted of lot of data before closing the database). Could you send me the database, or run the Recover tool and send me the last few lines of the .h2.sql file? To run the tool, start the H2 Console, then go to Tools - Recover. I'm mainly interested in the 'Statistics' part. For a small database, it is: ---- Transaction log ---------- ---- Statistics ---------- -- page count: 3890 empty: 0 free: 0 -- page data head: 646148 empty: 4333817 rows: 2722563 -- page count type: 1 96% count: 3761 -- page count type: 2 0% count: 32 -- page count type: 4 2% count: 88 -- page count type: 5 0% count: 5 -- page count type: 6 0% count: 1 When you open and then close the database, does the database file size shrink? If yes, how much, and could you repeat opening / closing until it doesn't shink; or run the statement SHUTDOWN COMPACT. Regards, Thomas -- 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.
