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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
