on 11-16-2016 4:32 AM
Hello Experts,
We are having problems trying to insert records in a custom BO, we receiving 50.000 records and we need add them to a custom BO, but that process spent almost 8 hours. I don't know what is the best practice to do it.
This is our code to do that:
var WA_Asig_Nuevo = ZMKT_UP_PARAM.Create();
foreach(var call in resultData1){
var wa_posic = WA_Asig_Nuevo.Distribucion.Create();
wa_posic.id_Key = Id.id_Key;
wa_posic.UUID = Llamada.UUID;
wa_posic.Propietario = WA_Curr_Cust.GetFirst().Propietario;
wa_posic.Fecha = Fecha_C;
wa_posic.Indicador = false;
}
I would like if someone can help us, Is there other way to improve this code? or to add records fast?
Regards
Ronald
Hi Ronald,
You could use mass enabled webservice and
enable mass for the events:
https://blogs.sap.com/2016/05/12/performance-best-practice-with-mass-enabled-event/
Thanks, Pradeep.You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks a lot for your answer, that process is already a MDRO process but it still taking plenty time running, I don't know if ther is a way to insert many records in one step. like in abap you can do it as: INSERT RECORDS INTO TABLE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ronald,
You could go for MDRO:
https://scn.sap.com/community/business-bydesign/studio/blog/2014/04/03/how-to-create-an-hourly-mass-..., Pradeep.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.