[firebird-support] firebird 3.0 ten times slower than 2.5 ?

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

Hi,

fb 2.5.7.27050_0_x64
fb 3.0.1.32609_0_x64

same table and data:

create table t1 ( id integer not null, n varchar(100))

commit

alter table t1 add primary key (id)

commit

//now insert 10 mln recs.

execute block as
declare i integer;
declare v varchar(100);
begin
i = 0;
while (i < 10000000) do begin
i = i + 1;
v = 'N'||i||'';
insert into t1 values (:i, :v);
end
end

commit

select count(*) from t1

//FB 2.5  time 4 sec.
//FB 3.0  time 6 sec

//now select first 1 mln recs order by id desc

select first 1000000 * from t1 order by id desc

//FB 2.5 time 11 sec
//FB 3.0 time 1 min 54 sec.



-- 
regards,
Michał Kurczabiński