This bug is a bug (we have 4 millions combinations not comparable with 100) and have been sorted by OPW with following patch. Eric
** Patch added: "location_report_11112011.patch" https://bugs.launchpad.net/bugs/882907/+attachment/2606791/+files/location_report_11112011.patch -- 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): 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 _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
