topic Re: performance on mass insert in Application Development and Automation Discussions

performance on mass insert

Former Member — Fri, 26 Feb 2010 11:30:52 GMT

Hiii

What is the best way to do mass insert in a custom database table

LOOP ITAB ENQUEUE ENDLOOP

MASS INSERT table from ITAB

LOOP ITAB DEQUEUE ENDLOOP

Note: can there be a performance issue doing it that way? since there are two loop

Re: performance on mass insert

Former Member — Fri, 26 Feb 2010 12:07:33 GMT

use

ENQUEUE

INSERT ZTABLE FROM TABLE IT_TABLE.

IF SY-SUBRC IS INITIAL.

COMMIT WORK.

ENDIF.

DEQUEUE

Edited by: Sachin Bidkar on Feb 26, 2010 1:23 PM

Re: performance on mass insert

Former Member — Fri, 26 Feb 2010 12:47:37 GMT

please note that here the enqueue i am not locking the whole table but will be locking only the entries data that i am inserting

Re: performance on mass insert

Former Member — Fri, 26 Feb 2010 12:51:27 GMT

But this is the standard practice what i mentioned and what i understood and as per information..

Edited by: Sachin Bidkar on Feb 26, 2010 1:51 PM

Edited by: Sachin Bidkar on Feb 26, 2010 1:52 PM

Re: performance on mass insert

StMou — Fri, 26 Feb 2010 14:40:51 GMT

HI,

Why are you lock entry that not in the system ?

Normally we lock entry to prevent another people to acces to this information.

But in your case, you are alone to have data.

Any row of your internal table are store in DB before ?

Rgds

Re: performance on mass insert

Former Member — Fri, 26 Feb 2010 14:53:05 GMT

Case 1:

INSERT implies you are pushing new records into your table. In this case you don't have to lock entry by entry and INSERT data into your table. This hampers the performance.

Case 2:

If you are handling an existing record in table, then you must use MODIFY. This statement will over write the existing records with your changes and if a record is not found, it would create a new entry in your table.

If either cases, its better to ENQUE, then do a mass update to table. Then,

if sy-subrc eq 0.

COMMIT WORK.

else.

ROLLBACK.

endif.

then deque.

Hope this helps.

Thanks,

Kiran