[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 u

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 bloc

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 modifyi

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" : > > On 2013-06-12 18:51, tsukasa wrote: > >> h2 database executes only 1 SELECT query at a time, even when autocommit >> is ON, blo