10-19-2009 7:36 AM
Hi there experts,
I need to update 500.000 times the REGIOGROUP of the Std address from the available BP on the system.
I'm using 'BAPI_BUPA_ADDRESS_CHANGE' at the moment, because imho this is the way to get it done.
But when i tested it on the testing system and tried als several jobs at a time, i came to the conclusion that i couldn't process more the 2200 business partner per hour. At this speed, it takes me 227 hours(10 days) to update the system!
For your info, replication to the CRM system stays also on.
Has any of you experts, suggestions to do the update in less time?
10-19-2009 7:47 AM
10-19-2009 7:47 AM
11-05-2009 7:39 PM
How about using transaction MASS. this allows you do to a mass update for the BPs.
Thanks n Regards
Dharmendra
11-05-2009 9:26 PM
Hi Jacco,
do not commit work after every call, do it every 5000 busines partnbers (I remember we got a lock table overflow after updating 10000 partners). This will increase performance significantly.
Also you can split into packets of BUPA number packets and schedule 4-8 jobs running parallel.
And, half a million is quite a lot. It needs its time.
Good luck.
Regards,
Clemens