Hi, Thanks a lot for reporting this issue! This should be fixed no (in the trunk).
Regards, Thomas On Wed, Mar 18, 2015 at 3:14 PM, Nicolas Fortin (OrbisGIS) < [email protected]> wrote: > 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. > -- 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.
