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: With PageStore ( good performance): 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.
