topic Re: commit each record in loop v/s bulk commit in Application Development and Automation Discussions

commit each record in loop v/s bulk commit

former_member599326 — Tue, 07 Jun 2022 11:45:34 GMT

Hi,

I have query. Which option gives best performance ?

Option 1 :- Committing record in loop per row.

Option2 :- Commit after loop, entire table in one go i.e. bulk commit.

e.g.

option1

LOOP AT it_mis INTO wa_mis.
INSERT z_mis_his FROM wa_mis .
COMMIT WORK.
CLEAR wa_mis.
ENDLOOP.

option 1

LOOP AT it_mis INTO wa_mis.
INSERT z_mis_his FROM wa_mis .
CLEAR wa_mis.
ENDLOOP.

COMMIT WORK.

Re: commit each record in loop v/s bulk commit

FredericGirod — Tue, 07 Jun 2022 11:47:14 GMT

make a trace, using transaction SAT for example, and you will find your answer.

(this problem is already known and discussed in IDOc integration)

Re: commit each record in loop v/s bulk commit

Sandra_Rossi — Tue, 07 Jun 2022 14:05:09 GMT

Please edit your question, select your code and press the button [CODE], which makes the code appear colored/indented, it will be easier for people to look at it. Thank you!

Re: commit each record in loop v/s bulk commit

Sandra_Rossi — Tue, 07 Jun 2022 14:06:31 GMT

I think it's more a question of ensuring database integrity. It's more critical than performance!

Re: commit each record in loop v/s bulk commit

ThorstenHoefer — Tue, 07 Jun 2022 15:12:36 GMT

Hi santosh.b2,

for a bult insert, I would use

insert z_mis_his FROM table it_mis .

Re: commit each record in loop v/s bulk commit

former_member808116 — Fri, 10 Jun 2022 07:36:48 GMT

insert z_mis_his FROM value wa_mis .