Hi, Sorry for double post. Mail client issues.
Regards, Nicolas Fortin Le vendredi 13 mars 2015 19:45:37 UTC+1, Nicolas Fortin (OrbisGIS) a écrit : > > Hi, > > With H2 1.4.186 we are experimenting a performance decrease between > PageStore and MVStore. > > With this sql query: > > drop table if exists test_update_perf;create table test_update_perf(X1 int > primary key, X2 double, X3 double) as select X X1, X+150 X2, X*X X3 from > SYSTEM_RANGE(0,15000);alter table test_update_perf add column X4 > double;update test_update_perf set X4 = (X3 - X2); > > H2 MvStore take a lot of time to update rows if they contains a primary > key. > > With MVStore > > [image: performance_mvstore.png] > > With PageStore ( good performance) > > [image: performance_pagestore.png] > > I understand that MVStore is currently in Beta. This message is only a > feedback on our observation. > > Thanks. > > Regards, > > > -- > Nicolas Fortin > IRSTV FR CNRS 2488 > GIS http://orbisgis.org > Spatial DB http://h2gis.org > Noise http://noisemap.orbisgis.org > > -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
