>For this particular type of the problem I think one by one record approach actually wins over a single update.

I got a result about one which was taking time. That one took 31 minutes. The first ones were faster because only a few records were processed based on some additional conditions I added. So, I will have to see if I can find a better approach from the interface or from the command line as far as the overall process.