0024264: The c_elementvalue_trg is performing and update when it is not needed. Can cause performance issues in some cases.

Anonymous | Login

Project:

View Revisions: Issue #24264		[ Back to Issue ]
Summary	0024264: The c_elementvalue_trg is performing and update when it is not needed. Can cause performance issues in some cases.

Revision	2013-10-17 17:20 by ngarcia
Steps To Reproduce	- Change the isactive field of a c_elementvalue - Notice that the update is performed

Revision	2013-10-17 17:20 by ngarcia
Description	The c_elementvalue_trg is performing and update when it is not needed. Can cause performance issues in some cases. The update is: UPDATE Fact_Acct SET AcctValue=:new.VALUE,AcctDescription=:new.NAME WHERE Account_ID=:new.C_ElementValue_ID; and it is performed always, although it is not needed.

Revision	2013-10-17 00:54 by ngarcia
Steps To Reproduce	- Change the isactive field of a c_element_value - Notice that the update is performed

Revision	2013-10-17 00:54 by ngarcia
Description	The c_element_value_trg is performing and update when it is not needed. Can cause performance issues in some cases. The update is: UPDATE Fact_Acct SET AcctValue=:new.VALUE,AcctDescription=:new.NAME WHERE Account_ID=:new.C_ElementValue_ID; and it is performed always, although it is not needed.