Cost of Update Transaction
In our current procedure for updating part cost in a table, we compare the field's value with the new value and if it is different, the record gets updated. This is done in a loop. Would it be faster to just update the field with the new value even if the value didn't change or is the cost of update higher than the cost of comparing 2 values?