Hey, 2016-04-25 Noel Grandin <[email protected]>:
> 2016-04-25 Nicolas Barbier <Nicolas Barbier <[email protected]>>: > >> I had no idea about the MVCC stuff (so we just used whatever H2 gave >> us by default). Maybe it would be useful to simple change the default >> from MVCC to non-MVCC when using PageStore? :-) > > MVCC can only be enabled explictly. I just added MVCC=FALSE to the connection string. So we now use “;IFEXISTS=TRUE;MVCC=FALSE” when opening an existing database, and “;MV_STORE=FALSE;MVCC=FALSE” when creating an empty database. Our source code doesn’t contain any other occurrences of the word mvcc (case insensitive), and the change to MVCC=FALSE really seemed to change the performance (quite dramatically). Therefore I guess that the default is not always to not use MVCC (when using PageStore)? Is there a way I can check whether MVCC is used after the connection is made? Or maybe older versions (such as 1.3.176) enabled MVCC implicitly, and this (default?) setting is stored in the database or so? Greetings, Nicolas -- A. Because it breaks the logical sequence of discussion. Q. Why is top posting bad? -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
