Hello,
I have improved my patch from comment #8 and created another patch
to solve this problem.
Eric, could you please test this patch if it improves performance of
your report?
Thanks,
Rifakat
** Changed in: openobject-addons
Status: New => Confirmed
** Changed in: openobject-addons
Importance: Undecided => Low
** Patch added: "location_report_lp882907.patch"
https://bugs.launchpad.net/openobject-addons/+bug/882907/+attachment/3309778/+files/location_report_lp882907.patch
--
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):
Confirmed
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
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
