c2c-oerpscenario team mailing list archive

Thread
Date

[Bug 552844] Re: Inventory too long

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: Quentin THEURET <quentin@xxxxxxxxxxx>
Date: Wed, 13 Oct 2010 08:00:52 -0000
Reply-to: Bug 552844 <552844@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

On stock/product.py, the get_product_available function searches all
products if no product ids are given to this function.

I have 350,00 products, so it's more long to search ids of all products.

A solution is to create a table which contains an entry by
product/location with the number of products in this location. But this
solution ask a big work to update these entries at each stock move.

-- 
Inventory too long
https://bugs.launchpad.net/bugs/552844
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in OpenObject Addons Modules: New

Bug description:
With large stock location (about 2000 locations), and few product ((test base with only 5 products in stock), try to fill inventory.
Server say connexion refused and seems to continue. (cpu charge with nobody working)
About 5 minutes and nothing.
Another way to fill inventory ?

postgresql 8.4
debian 5.0
openerp 5.0.7