commit each record in loop v/s bulk commit

[former_member599326]

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.

[FredericGirod]

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

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

[Sandra_Rossi]

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!

[Sandra_Rossi]

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

[ThorstenHoefer]

Hi santosh.b2,

for a bult insert, I would use

insert z_mis_his FROM table it_mis .

[former_member808116]

insert z_mis_his FROM value wa_mis .