Skip to Content
Menu
This question has been flagged
2095 Views

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

Avatar
Discard
Author

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?

Related Posts Replies Views Activity
2
Sep 23
7015
0
May 23
993
0
May 21
7958
4
Apr 20
7548
1
Nov 19
2895