Skip to Content
This question has been flagged
4 Replies
5319 Views
Avatar
Stephen Chan

Hi,

I tried to search 'picking document slow' but did not find any related post.

We're on Enterprise v10. I have an inbound picking document with 69 items (created from a Purchase order with 69 items). The inbound picking document is using From location: Vendor  To location: IN for all the items.

I pressed the VALIDATE button and it took 36 mins and 15 seconds to complete. 

Is it normal and standard?

We have over 30000 storage locations in Odoo.


Our Odoo server is on AWS EC2 using m4.large and DB RDS server is using db.m3.medium

During the test, the Odoo server CPU utilization is around 20% and DB CPU utilization is over 90%.

And I am the only user in the system.

Will I get improvement on v11 (3x faster than v10) for my case?

Please advice what settings on Postgresql or Odoo I need to check in order to improve this.

Avatar
Discard
Avatar
肖相扶
Best Answer

Hi, Fabien, Stephen

Odoo 13.0, The reason is :

1) When stock.valuation.layer is big, method _run_fifo_vacuum (code file:  stock_account\models\product.py) is very slow. On my production Odoo server, it takes 3 seconds every call .
2) In code file: stock_account\models\stock_move.py,  _run_fifo_vacuum is called too many .
     this code:

        for product_to_vacuum in products_to_vacuum:
            product_to_vacuum._run_fifo_vacuum(company)

    should be:

        products_to_vacuum._run_fifo_vacuum(company)

3) Method _run_fifo_vacuum should  not be  "ensure_one" 

Avatar
Discard
Avatar
Stephen Chan
Author Best Answer

Hi Fabien,

Thanks for your reply.  Yes, we have custom modules installed and our Enterprise is implemented by a partner. 

However the partner still cannot identify the root cause and they suspect the large volume of storage location caused this performance issue.

That's why I post this to the forum and see if other folks got the same performance issue related to large volume of storage locations.

BTW, nice to meet you last week in the Hong Kong Odoo event. I'm the person who asked the question of Python 2 and 3 during the Q&A session.

Avatar
Discard
Md. Tanzilul Hasan Khan

I know it's very long time to ask but, did you find any solution to this?

Avatar
Fabien Pinckaers (fp)
Best Answer

If you use Odoo Enterprise, you can contact support at odoo.com/help


Upgrading to v11 would help a lot, but contact support first; we have fixed several issues like that and we have patches you can try.


Something is definitely wrong in your server, as this performance is not what we notice on similar volumes. Do you have custom or community modules.

Avatar
Discard