[h2] Insert in 1.4 is much slower than 1.3

2014-08-27 Thread Isaac Zhu
Hi, Our application is using H2 as the core database in embed mode. And we have a view with about 100,000 rows. To accelerate the querying, we create a table that has the same column with the view and create indexes on some columns. We update the table with the data in the view periodically, in

[h2] MULTI_THREADED=1 get error in 1.4 beta

2014-04-22 Thread Isaac Zhu
Hi, I'm tring out the 1.4 beta which declared having better supporting to MULTI_THREADED & MVCC mode. In 1.3.x, I was using this connection string in my application: jdbc:h2:mem:test;MULTI_THREADED=1 But in 1.4 beta, it turns out an error when I tried to create a connection with the same string: