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)?