Version 1.4.197 is much slower then previous versions like 1.4.196

[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 (> 100000).
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 upgrading from 1.3.167) and both Versions where as fast as the old 1.3.167.
So it seems, the Performance Issue was introduced in Version 1.4.197.

I use the following connection url:
jdbc:h2:./h2/h2;LOG=2;AUTO_SERVER=TRUE;MVCC=true;WRITE_DELAY=100

Any Reason for that?

Martin

[Noel Grandin]

If you can generate a standalone test case, we can profile it

[Im Ernst]

Hi Noel,

i could not reproduce with the same table, indexes and inserts outside of the main application. The real world application has hundrets of tables, so currently i cannot say what i need to add to the testcase.

But i did a quick sampling with jvisualvm.
t1.jpg shows Version 1.4.197 using a lot of time in comparing Strings.
t2.jpg shows Version 1.4.196. The inserts where done very fast.

stack1.jpg and stack2.jpg show 2 random Stack Traces of the running Version 1.4.197.

Hopefully that helps

[Noel Grandin]

Unfortunately that does not tell me enough to be able to fix that.

If you can build from source, perhaps you could bisect the problem down to a specific commit?

[sandeep tiwari]

i am also facing same slowness issue after upgrading from h2-1.3 to h1.4.196.

if we are executing plan query like select * from some_table then it's works fine,But when we are using any join,where, union clause or Aggregate Function with group by and order by then h2's performance is versy slow.Same query when we are executing with h2-1.3 driver it was taking time 0.3 MS, but with h2-1.4 taking 3.28Sec time.