Odoo 12 Enterprise - performance issues.
Has anyone solved this or ran into this scenario?
Steps to duplicate this issue:
Sale Order with 500 line items that have an order quantity 12 each line item. On the delivery ticket you have 500 line items and 12 initial demand and 12 reserved. Edit the delivery ticket and mark the Done = 1 due to only shipping out 1 product at a time. Validate the delivery ticket and get the back order or no back order screen. Of course choose back order. The UI say go get some coffee and generally a timeout will occur under standard configurations.
Issue of performance leaks and or timeouts: the process of 500 line items take over 20 minutes?? Using the conventional UI (Create Back Order Button ) on the server would eventually timeout (memory limit, cpu limits) ect.. unless self hosting one could adjust these limits but not good practice to have a cpu limit of 2400+ right? It doesn't seem to make much of an impact increasing workers or even better hardware (some increase not much)? Tried also using batch picking did not solve the problem the copy and create of a new move internally in action_done of stock_move takes around 3-5 seconds per record?
Current Workaround: created a module to process these delivery tickets using a cron job. What is noticed here is a 1 cpu is loaded at between 80-100 percent until this job completes.
Community Suggestions on how to speed this up without completely re-writing stock_move action_done in sql?
Thanks,
Justin Freres