How do you improve the performance of receipt validation with a large number of lot/serial numbers? To validate a receipt w/ 10k lot numbers it currently takes ~33 Minutes to process, which is unacceptable. With the help of Odoo support, we have done the following:
- Configure Odoo to work with several workers and tuned some Postgresql parameters.
- Disable the message tracking during the process. This has reduced the validation time by roughly 20%.
But, the validation is still too long (26 minutes for 10K lot numbers)
- The Odoo support team then explains that long validation time is mainly caused by the creation of account moves (because the received product is set with an automatic inventory valuation). Periodic inventory valuation, however, cannot be used because it is unsuited for our business.
At this point, Odoo support is not willing to spend anymore time on the issue and is asking us to pay to fix this performance issue: "Odoo is not tailored to process as many account moves as you request in an acceptable time for you. We can work on a tailor made solution. In that case you need to buy a partner pack. If you decide to go on this way, could you contact your account manager."
Does anyone have a solution for this performance issue? Does anyone know if it has been fixed on Odoo V11 or V12
Server specifications:
Google Cloud Compute instance
CPU: 2 vCPUs (Intel Broadwell)
Memory: 8GB
Zone: asia-southeast1-b
OS: Ubuntu 16.04.5 LTS (Xenial Xerus)
Disk: Standard Persistent Disk 100GB (Zone: asia-southeast1-b)
Number of concurrent users: 10
did you solve this?