I think everyone reading this list would like to hear a well-grounded answer to this question.
But I quess no one is capable of answering questions of this magnitude.

- Rami

On 23.5.2013 14:45, aditya wrote:
Hi,

I wanted to know if it is recommended to use the MVCC parameter with an 
in-memory h2 database and
are there any risks involved if it is used in production environment?

We have some scenarios wherein concurrent access to DB is required and if MVCC 
is not used,
it results in error 'timeout trying to lock table' (even on SELECT queries and 
in cases where we have nested transactions).

We are using H2 version 1.2.147 but if required we can switch to the latest 
version.
However, even the latest H2 documentation says that MVCC feature is still 
experimental.

And are there any other alternatives to MVCC, to achieve better concurrency in 
such situations? A quick response would be highly appreciated.

Thanks,
Aditya
--
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.
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.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to