openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #01732
[Bug 882907] Re: stock location content report not optimized
Hello Ian Le,
I have checked this issue at my end but I did not face any problem. I have created a 100 +
products and assign in to same location, then I have printed a "Stock location content"
report and its working fine.
I have attached a video for your more reference, So would you please check it and notify us where you have faced the problem.
That is better if you can provide us your end database so we will check it properly.
Thanks and waiting for replay.
** Changed in: openobject-addons
Status: New => Incomplete
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/882907
Title:
stock location content report not optimized
Status in OpenERP Addons (modules):
Incomplete
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