Hi All,
I have an fbk, restore with 2.5, 3.0 and 4.0, then execute the next with
isql:
execute block
AS
declare variable stmt varchar(200);
begin
for select 'DROP TRIGGER '||trim(rdb$trigger_name) from rdb$triggers
where rdb$system_flag=0
into :stmt do
begin
in autonomous transaction do
execute statement :stmt;
end
end
Any idea why 4.0 much slower than 2.5 and 3.0? (I see a big difference
at Reads/Writes.) The numbers below, executed three times per version
and quoted the best result. All are Win64 SuperServer.
2.5.9
Current memory = 53658824
Delta memory = 17606432
Max memory = 59377304
Elapsed time= 25.14 sec
Buffers = 2048
Reads = 63889
Writes 42653
Fetches = 33908917
3.0.8.33468
Current memory = 92970704
Delta memory = 51164224
Max memory = 96741936
Elapsed time= 31.430 sec
Buffers = 2048
Reads = 60772
Writes = 40179
Fetches = 22413097
4.0.0.2496
Current memory = 66954960
Delta memory = 25786128
Max memory = 87218048
Elapsed time = 46.116 sec
Buffers = 2048
Reads = 92986
Writes = 93249
Fetches = 22553868
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
