Hi, Strange, it only seems to be a problem if there is an "alter table". If X4 is added at the beginning, then it's fine.
Regards, Thomas On Friday, March 13, 2015, Nicolas Nico <[email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
