Re: [h2] why one query at a time

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

Re: [h2] why one query at a time

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 noelgran...@gmail.com: On 2013-06-12 18:51, tsukasa wrote: h2 database executes only 1 SELECT query at a time, even when autocommit

[h2] why one query at a time

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

Re: [h2] why one query at a time

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