Subject | Re: [firebird-support] RE: Table update performance dropped significantly within few days. |
---|---|
Author | Helen Borrie |
Post date | 2014-01-16T07:50:50Z |
At 07:15 p.m. 16/01/2014, brucedickinson@... wrote:
ALTER TRIGGER CLIENT_LM INACTIVE
AFTER INSERT OR UPDATE POSITION 1
Do you know if or when the trigger was ACTIVATED? It's very hard to see how deactivating a hungry trigger like that one could *degrade* performance.
Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________
>One thing I do not understand. If the trigger has been installend over two months ago, why performance degraded just few days ago and not immediatelly after the trigger has been activated?You might be shooting at rainbows. Your colleague altered the trigger and made it INACTIVE:
ALTER TRIGGER CLIENT_LM INACTIVE
AFTER INSERT OR UPDATE POSITION 1
Do you know if or when the trigger was ACTIVATED? It's very hard to see how deactivating a hungry trigger like that one could *degrade* performance.
Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________