Hi All,

I'm doing a function which can recalculate cost of product in a list. The record of list is storing at database. Since the user would like to recalculate the cost the program will copy exactly same product spec and generate a new reference number without overwrite exist data.

Hence, I had faced a problem with what is best method to reduce the time expand of transaction ?

My suggestion is using store procedure to create a view with new reference number and calculate the changed of product cost. After calculation function is done, the SPROC will copy back the new view record back to table.

it is the best solution ?

can someone provide me better way ?


thanks a lot