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);
al
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 wrote:
> Hi,
>
> With H2 1.4.186 we are experimenting a performance decrease between
> PageStore and MVStore.
>
>
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 ta