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 ?

How long does the insert operation take? Usually, inserts are very fast with the H2 database, so it should not be a problem. — Thomas Mueller
– Thomas Mueller, Commented Mar 3, 2013 at 19:32

Thomas Mueller · Accepted Answer · 2013-03-03 19:31:37Z

2

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.

answered Mar 3, 2013 at 19:31

Thomas Mueller

50.4k16 gold badges123 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dreampowder Over a year ago

i will try to work with multi-threaded option and tell the results.. But so far, im not thinking about switching from h2 database as i am looking for an embedded db and it works great besides this thing..

dreampowder Over a year ago

Nope, multi_threaded didny help, anyway i've decided to stay like that. those lock ups take just a few seconds and it happens if the data is queried in the same time with the update operations. Thanks anyway

Collectives™ on Stack Overflow

Java Play Framework + H2 Database, Concurrent operation performance

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related