c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <882907@xxxxxxxxxxxxxxxxxx>]

Hello Eric!

you may want to have a look into 
http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/files/head:/stock_location_product_not_null/

which requires our patched server version which allows server side filtering of function fields from
https://code.launchpad.net/~c2c/openobject-server/6.0-c2c-official

indeed we would be interested to hear if this works well (or not) for
these very big amount of data.

obviously, if stock quantities have to be calculated for every request
it's a burden and the only way out is to create materialized views
(aggregates) and/or other workarounds

we are experimenting with account period sums
http://bazaar.launchpad.net/~c2c/c2c-rd-addons/trunk/files/head:/chricar_account_period_sum/
to avoid similar problems
this module uses postgres triggers to create and update period sums and worked well in a similar installation on another ERP-DB system for 1 million moves a day.  it does not need any python code modifications hence it is quite independent and very fast.
I am very sure that OpenERP will need a similar solution for stock_move soon.

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