Many thanks Thomas, Just for my interest have you blogged anywhere about pros and cons of the different isolation levels?
Lucene is great for snapshot isolation but I guess you would have file descriptor problems pretty quickly. Cheers Sam On Jan 20, 8:12 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > > Would I be right in thinking that Lucene/FTL index does not honour > > MVCC session isolation? > > Yes, the fulltext search is updated as soon as the changes occur > (before they are committed). > > > Also that H2 does not support MVCC Snapshot isolation? > > The MVCC implementation of H2 doesn't completely match other MVCC > implementations. H2 doesn't support snapshot isolation, but read > committed instead. This has advantages (I think the implementation is > simpler and faster) and disadvantages (it's not fully compatible with > PostgreSQL and Oracle). Please note that snapshot isolation is also > problematic for certain use cases. > > Regards, > Thomas -- 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.
