We currently have an oninsert() trigger set-up that everytime a row is insert into a table an update query fires off to update 3 fields. The fields are a simple calculation such as
field1update = (amt/12)*14
field2update = (amt/12)*16
field3update = (amt/12)*18
The trigger is adequate, but it will sometimes lock the row so it can not be immediately accessed for a moment. My question being if these fields were converted to a (please excuse my ignorance) calculated column or a computed column would we see performance improvement?
Usually this is a spreadsheet import and is roughly 20,000 - 25,000 rows being inserted at a time.