H2 DB performance deteriorates after migration with Spring Boot 3

[Dhanasekar Rengasamy]

-1

We have migrated a Spring Boot 2.x to Spring Boot 3.x and still using the same H2 version 2.1.210. Internally it uses the whole stack (Spring data JPA, Hibernate, Hikari etc.)

We found that H2 performance drastically decreased with Spring boot 3.x. It is taking more that Hrs when inserting 150,000 rows in H2 table, earlier it was less than 5 min.

Kindly suggest, what config changes may be needed to improve the DB performance?

Thanks in advance!!

[Dhanasekar Rengasamy]

We are using H2 db as in-memory mode.

Thanks.