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. > 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. > > > -- 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.
