c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #35947
[Bug 882907] Re: stock location content report not optimized
Just 2 questions:
1) You are talking about
Menu > Warehouse > Inventory Control > Location Structure ->> Wizard "Stock Location Analysis" ?
2) Do you want to display products with both "real stock" =0 and
"future stock" = 0 as I assume not all 15000 will be in every stock
location?
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/882907
Title:
stock location content report not optimized
Status in OpenERP Addons (modules):
New
Bug description:
We are using OpenERP 6.0.3 with WEB-UI, we have roughly 15,000 products and 250 internal locations.
Every time we trying to generate report of content of one or some locations, the server will consuming a lot of memory ( around 1-1.5Giga), and some time we got timeout error of web-ui.
After a little investigation, we think it is because in _product_get_report() of stock.py, if product_ids is not provided, it will indiscriminately get all the product ids:
if not product_ids:
product_ids = product_obj.search(cr, uid, [], context={'active_test': False})
We think it may get related product ids with the location ids given
first, will it be feasible?
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/882907/+subscriptions
Follow ups
References