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 u
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 bloc
On 2013-06-12 18:51, 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. --
We only lock the database while actually fetching or modifyi
Hi,
With the new storage subsystem "MVStore" it should be much simpler to
support concurrent operation.
Regards,
Thomas
Am 13.06.2013 09:51 schrieb "Noel Grandin" :
>
> On 2013-06-12 18:51, tsukasa wrote:
>
>> h2 database executes only 1 SELECT query at a time, even when autocommit
>> is ON, blo