How Best to Update Multiple Fields?

Need help Database
1

I am updating fields in a record using a BE-WF and I wanted to know which was most efficient:

  1. Update all records regardless of whether there’s a change
  2. Update each field one at a time in the WF depending on a check to see if the value has changed

Any thoughts or alternatives?

2

Updating on each field seems less WorkUnit which is better But you dont know which field are updater unless you do complex condition so to save complixty which in every case must be prevented update all records is best option as for me.

You can also use auto-bound option too , a good alternative.

1 Like