I'm not sure sorry, someone else might be able to answer for you. I
could only suggest give it a go and see if it works. I don't see why it
wouldn't work, you are only changing transaction isolation level.
Thanks, Ryan
On 13/01/2013 6:24 PM, Matouš Voldřich wrote:
Thanks for answer. We will give it a try and at write some tests.
Could you answer my second question? Is it possible to set LOCK_MODE=0
and still use cluster mode?
Thanks
Matous
Dne sobota, 12. ledna 2013 15:34:27 UTC+1 Kartweel napsal(a):
MVCC has been around for a while, so it is pretty stable. But I
did find a bug the other day with "for update" and lobs, so it
still has bugs. It isn't as well tested as the rest of the engine,
and not as well supported :)
Ryan
On 11/01/2013 6:35 PM, Matouš Voldřich wrote:
Hi,
I would like to ask about H2 feature MVCC (multi version
concurrency). On some places this feature is marked as
experimental so I would like to ask about its status. Is it ussable?
We would like to prevent locking of entire table. Are there any
other options? I found only to use LOCK_LEVEL=0 since we do not
need transactions at all (we use it as simple
INSERT-GET-UPDATE-DELETE store). But we also use cluster, so I'm
not sure if setting it will not disable the cluster functionality
as well.
Thanks.
Matous
--
You received this message because you are subscribed to the
Google Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/IPVunNjiwuUJ
<https://groups.google.com/d/msg/h2-database/-/IPVunNjiwuUJ>.
To post to this group, send email to [email protected]
<javascript:>.
To unsubscribe from this group, send email to
[email protected] <javascript:>.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
<http://groups.google.com/group/h2-database?hl=en>.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/vImI06FfFZMJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.