[h2] MVMap similar to LinkedHashMap

2018-04-20 Thread ivan
Hi, Is it possible to turn of the sorting feature in MVMap and follow the insertion order? Thanks Ivan -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Version 1.4.197 is much slower then previous versions like 1.4.196

2018-04-20 Thread Noel Grandin
If you can generate a standalone test case, we can profile it -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post

Re: [h2] Very slow execution times for SELECT-statements with lots of LEFT OUTER JOINs after updating on H2 version 1.4

2018-04-20 Thread Noel Grandin
EXPLAIN ANALYZE will show you what plan the db is executing, something in the planner is generating a worse plan now. Your best bet is to generate a standalone test case for us to look at. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

[h2] Version 1.4.197 is much slower then previous versions like 1.4.196

2018-04-20 Thread Im Ernst
Hi, i've upgraded from Version 1.3.167 to 1.4.197 with Backup and Restore. After Upgrading i inserted a large number of Rows (> 10). That took more then one minute while the same thing in the old Version needs only a few seconds. I checked against Version 1.4.194 and 1.4.196 (Each time

[h2] Very slow execution times for SELECT-statements with lots of LEFT OUTER JOINs after updating on H2 version 1.4

2018-04-20 Thread 'Ivaylo Dobrikov' via H2 Database
Hello folks, in our firm we are using H2 for our test suite to perform various of integration tests for our applications. Recently, we updated to H2 1.4.196; until the day of the update, we used an older version of H2 1.3.166. We found out that the execution times of some test cases became