Hi, I don't know why it is slow. Could you use the built-in profiling tool to find out details? See also http://h2database.com/html/performance.html#application_profiling
Regards, Thomas On Tue, Feb 21, 2012 at 10:13 AM, Kasja <[email protected]> wrote: > Hello, i'm using h2 with hibernate, database file ~ 570 mb, db has > ~650 records with blobs. Everything is fine, except for closing time > in embedded mode (in server mode everything is ok). > > 02-21 10:15:11 database: closing F:/data/chancery from shutdown hook > 02-21 10:15:11 database: disconnecting session #2 > 02-21 10:15:11 database: closing F:/data/chancery > 02-21 10:16:32 database: closed > > Why it takes so much time? > Dialect: org.hibernate.dialect.H2Dialect > Driver: org.h2.Driver > Hibernate 4.1.0 > H2: h2-1.3.164.jar > connection string: jdbc:h2:F:/data/ > chancery;IFEXISTS=TRUE;SCHEMA=CHANCERY_SCHEME;CACHE_SIZE=131072;TRACE_LEVEL_FILE=3;TRACE_MAX_FILE_SIZE=20 > > Here's full stack trace if someone's interested : > http://www.mediafire.com/?f8o8q1aubruhpdc > > -- > 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. > -- 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.
