Hi again,
I created a test case which shows the problem, using a new database.
Firebird CS 2.5.1 running on Windows 7, default firebird.conf.
Time to insert 200.000 records in a single-field table:
/*
* Integer field, no PK
*/
create table t1 (
id integer not null);
set term !! ;
execute block
as
declare variable i integer;
begin
i = 0;
while (i < 200000) do
begin
insert into t1 values (:i);
i = i + 1;
end
end !!
set term ; !!
TIME: 2s199ms
/*
* Integer field, with PK
*/
create table t2 (
id integer not null);
alter table t2
add constraint pkt2 primary key (id);
set term !! ;
execute block
as
declare variable i integer;
begin
i = 0;
while (i < 200000) do
begin
insert into t2 values (:i);
i = i + 1;
end
end !!
set term ; !!
TIME: 3s869ms
/*
* UUID field, no PK
*/
create table t3 (
id char(16) character set octets not null);
set term !! ;
execute block
as
declare variable i integer;
begin
i = 0;
while (i < 200000) do
begin
insert into t3 values (gen_uuid());
i = i + 1;
end
end !!
set term ; !!
TIME: 2s542ms
/*
* UUID field, with PK
*/
create table t4 (
id char(16) character set octets not null);
alter table t4
add constraint pkt4 primary key (id);
set term !! ;
execute block
as
declare variable i integer;
begin
i = 0;
while (i < 200000) do
begin
insert into t4 values (gen_uuid());
i = i + 1;
end
end !!
set term ; !!
TIME: 1m53s587ms <-------------------
I created a new database and ran the last test again:
TIME: 4m00s881ms <-------------------
Regards,
Fabiano
