Java Play Framework + H2 Database, Concurrent operation performance

Question

I have a play framework application that uses H2 Database. In general, the application have several scheduled "Jobs" that inserts data into the database (From an external Firebird database), and a controller layer that presents the stored data to the user in xml format via get requests.

My question is, while there is a job inserting data into the database, even just a few lines, the database seems to be unresponsive until the insert operation is complete. (Select queries are waiting until the other operation completes).

i am using standart Play Framework H2 connection string with "MVCC=TRUE" addition.

btw. The server is running on windows platform + Apache Tomcat server.

Is there any additional parameters or settings that i can do to get over this "unresponsiveness" problem ?

Answer 1

By default, H2 serialized the statements. You have multiple options:

• Insert less data at a time (fewer rows in each statement) so that the database is not blocked for a long time
• Enable multi-threading using the multi_threaded option, but in this case you can not use the mvcc feature unfortunately.
• Use a different database.