← Back to team overview

openerp-india team mailing list archive

Re: [Bug 882907] Re: stock location content report not optimized

 

Thanks Ferdinand,
We will have a close look, test it for our installation and feedback asap.

It helps but does not solve original problem which is the "location 
content" calculation is not optimized.


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



** Attachment added: "Logo-Elico90.gif"
   https://bugs.launchpad.net/bugs/882907/+attachment/2578691/+files/Logo-Elico90.gif

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


References