Skip to Content
Aug 09, 2011 at 01:38 PM

Performance of Modify or Insert of 4.500.000 records to DB


Hello all,

I have a performance problem with the insertion of 4.500.000 records to the database table z_tab. The statement is as follows:

MODIFY z_tab FROM TABLE <lt_tgt>.

The table z_tab is empty, but this statement dump with the time_out error.

If I do it with following statement:

INSERT z_tab FROM TABLE <lt_tgt>.

it finished in 156 seconds. I suppose that MODIFY is slower than INSERT, but not so dramatic. Is it really a problem of slow MODIFY statement or it could be a problem of DB (settings)?

Kind regards