Subject Logging time spent in trigger
Author yellowsquirrel42
Hi all,

i'm not an experienced sql user and new to firebird. Maybe someone has
a simple solution for my problem.

I have a firebird database with many triggers. One of my tables is
named Patient. If i delete all patients in the table, a cascading
delete will occur and rows from other tables will be deleted aswell.
The problem is that a statement like

delete * from Patient;

lasts very long (about 30 minutes for 400 rows). Is there a simple
approach to log the time each trigger in the cascading delete needs ?