VB Excel add-in - Batch Upload Slow Performance issue with high volume order lines
Summary:
Slow performance using VB Excel bulk load lines for Order using FA order Lines API.
The requirement is to bulk create 500+ lines per Order. Only 1 order is allowed to be entered at a time with Form based layout.
The FA API in question is /salesOrdersForOrderHub/{salesOrdeNo}/child/lines
It is observed the add-in is unable to scale after a certain point (first 200+ lines created in 90 secs) and the performance starts to degrade to a slow crawl. The next 100+ records could take beyond 10 ,15 or more minutes.
Again this is well short of our 500 lines target. We have not been able to do 500 lines yet.
Tagged:
0