c2c-oerpscenario team mailing list archive

["Eric Caudal - www.openerp.net.cn" <eric.caudal@xxxxxxxxxxxxxx>]

Hi Ferdinand,
1.we are talking about the reports in warehouse/configuration/location 
"location inventory Overview" and "location content".
In those 2 reports, the above mentioned function gets all the products 
and then calculate one by one all stocks for all locations (we have more 
than 250 locations).
Ideally OpenERP should first select the products that are in a move 
from/to the given location(s) and then calculate the stock for the 
location(s).
2. this point is as well a p... in the a...: with 15000 products of 
which 800 are not null at a given moment, getting a stock list is a 
challenge in OpenERP. Having the possibility to filter (and sort!) the 
products with real and/or virtual stock would be great.


openerp 	

*Eric CAUDAL*, CEO
eric.caudal@xxxxxxxxxxxxxx  <mailto:eric.caudal@xxxxxxxxxxxxxx>
Cell: + 86 186 2136 1670
*Elico Corp - OpenERP Ready Partner, Shanghai.*
http://www.openerp.net.cn

-- 
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