Triggers can initiate other triggers or a trigger can initiate itself (recursive trigger). The maximum number of nested or recursive triggers can be set with the SQL.MaxNestedTriggers parameter, see SQL section.
[SQL] MaxNestedTriggers = n;
where n is the maximum number of nested triggers.
The default number for nested triggers is 16.
Setting the trigger cache
Triggers are cached in a separate cache. Each user has a separate cache for triggers. As the triggers are executed, the trigger procedure logic is cached in the trigger cache and reused when the trigger is executed again.
You can set the size of the trigger cache by using the SQL.TriggerCache parameter, see SQL section.
[SQL] TriggerCache = n;
where n is the number of triggers being reserved for the cache.