Skip to content

Slow drop trigger command execution under FB5.0 #7767

@omachtandras

Description

@omachtandras

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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions