By Default H2 run single threaded, so when a statement is executing, it
blocks everything else. See
http://h2database.com/html/features.html#multiple_connections
You can turn on multithreaded mode if you really need the concurrency,
or have single long running statements and don't want to block
everything else. Append MULTI_THREADED=1 to the connect URL, but it is
not as well tested as single threaded mode.
Generally you get better performance in single threaded mode where the
disk IO is the limiting factor.
On 13/06/2013 12:51 AM, tsukasa wrote:
h2 database executes only 1 SELECT query at a time, even when
autocommit is ON, blocking everything else, why is that? it's not
going to change? to an outsider it looks like a simple feature. --
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
