Triggers can invoke other triggers or a trigger can invoke itself (recursive trigger). The maximum number of nested or recursive triggers can be set with the SQL.MaxNestedTriggers parameter.
[SQL] MaxNestedTriggers = n;
where nis 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 using the SQL.TriggerCache parameter.
[SQL] TriggerCache = n;
where nis the number of triggers being reserved for the cache.