Hi devs, I've got a H2 (created with h2-1.3.153) database with two tables. Each table is created as follows: "CREATE TABLE (ID INTEGER PRIMARY KEY AUTO_INCREMENT, CONTENT BLOB NOT NULL, DESCRIPTION VARCHAR NOT NULL, STAMP BIGINT DEFAULT NEXT VALUE FOR GLOBAL_STAMP_SEQUENCE)". Both blob & varchar aren't very big: blob is around 1 kB, varchar is a few hundred characters. The row count in the two tables is as follows: 1 205 050, 4 660 558. The total size of the DB on disk is over 7 GB. I use the following URL to create/connect the DB: 'jdbc:h2:split:my_path;PAGE_SIZE=1024'. There is only one connection to the DB.
The problem is that the DB closing time is extremally high: for the first time it takes over 300 seconds on a decent PC (Intel E6600, 2 GB RAM) under WinXP! Consecutive opens/closes take over 40 seconds. The AV scanner is off. During that process the CPU usage is rather low (approx. 15%) and so is the I/O throughput (no more than a few hundreds kB/s; it jumps to more than 10 MB/s for a few seconds just before finish). I tried adding 'MAX_COMPACT_COUNT=0;PAGE_STORE_TRIM=false' to the URL but this hasn't helped a bit. At the moment I'm not sure if 'SHUTDOWN IMMEDIATELY' is a viable option to me as it causes my testcases to fail (I inspected them - they look fine). The same behaviour can be observed using the H2 cosole: connecting and then disconnecting immediately is ugly slow. Of course I'll try to solve the problem on my own but if any of you can drop me an ad hoc idea what should I try I'd be grateful. Regards, wburzyns -- 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.
