Issue: SAVE_ALL takes lot of time. 5-60 minutes based on number of entries.
1. Screen ONE has selection screen.
once we execute(F8)
2. we get Screen TWO, with table control populated based on selection. with two buttons: CONDITIONS & SAVE ALL
2.1when CONDITIONS is Clicked, THIRD screen with some 72 lines in table control is generated with many validations.
2.2when SAVE_ALL is clicked all items in the second screen are looped and the necessary conditional data is populated. and saved one by one for each item.
LOOP AT IT_ITEM INO IS_ITEM.
Perform2.(with select statements....)
Perform SAVE. (with modify dbtab from itab statement.)(everytime ITAB will have 72 lines)
NOW, when we click SAVE_ALL this is taking lot of time.5 - 60 minutes.
IF little data like 10items, it takes hardly 10seconds.
mostly... we have data like: 1500(items) * 72 = 108000 lines
Now.... I dont want to disturb the existing logic by taking select statements out of the performs etc.
Can someone suggest me something?
Can we push this to background processing ? or any other way.....
if yes, pls guide me.