Hi,
something went wrong under 5.0.
Dropping 2366 triggers
5.0 RC1: 18 min
4.0.3: 38 sec
3.0.11: 43 sec
Sample code to test:
execute block
as
declare variable trg_drop type of column rdb$triggers.rdb$trigger_name;
begin
for select 'DROP TRIGGER '||trim(rdb$trigger_name)
from rdb$triggers
where rdb$system_flag=0
into :trg_drop do
begin
in autonomous transaction do
begin
execute statement :trg_drop;
end
end
end
Hi,
something went wrong under 5.0.
Dropping 2366 triggers
5.0 RC1: 18 min
4.0.3: 38 sec
3.0.11: 43 sec
Sample code to test:
execute block
as
declare variable trg_drop type of column rdb$triggers.rdb$trigger_name;
begin
for select 'DROP TRIGGER '||trim(rdb$trigger_name)
from rdb$triggers
where rdb$system_flag=0
into :trg_drop do
begin
in autonomous transaction do
begin
execute statement :trg_drop;
end
end
end