Using update module VS updating DB within the program

[Former Member]

Dear experts,

In a book that I read, in comparing between using update function module to update database VS using UPDATE statement within my program, it is said that updating within my program may use several DB work processes. Therefore, it may have poor DB performance. Does it mean if I have several UPDATE statement in my program, then each statement were executed by different DB work process?

Thanks in advance.

Regards,

Haris

[SureshRa]

Direct UPDATE statements execute DB LUW (Logical Unit of Work) and effect the changes to the database immediately which can not be reverted using ROLLBACK.

If you update through update work-process (update task), till COMMIT, you have an option to ROLLBACK.

There is no concept of DB work process. Hope this clarifies your doubt.

Also there is no performance issue by using many UPDATE statements in your program - However it is a poor programming practice not to handle SAP LUW.

Regards

Suresh