I've been using MVCC for quite a while. It appears pretty stable, but
there is a bug with FOR UPDATE and LOBS. (It doesn't work), so there are
still bugs. Furthermore MVCC is not really supported by anyone, so if
you come across bugs you'll probably need to fix them yourself.
I think once the new MVStore is operational then MVCC will be much
better supported??
Ryan
On 23/05/2013 7:51 PM, Rami Ojares wrote:
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.