c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <770243@xxxxxxxxxxxxxxxxxx>]

@David, Raphael: thanks a lot for the detailed explanation, I understand
better the use cases now.

I was thinking of the multiple dimensions we have for journal entries:
e.g each entry can be linked to a Partner, which allows per-customer
bookkeeping. Perhaps a similar concept at stock.move level would help in
some cases (e.g. consigned stock). And/or another dimension for
"sublocations" could save the trouble of multiplying first-class
locations. Of course these other dimensions only make sense if you
really have the same concepts in your warehouses, e.g. if you do store
consigned products from multiple customers in the same physical
location, etc.
We're thinking of doing something like that for 6.1, but of course this
doesn't solve the other shortcomings David describes for retail
distributors.
Anyways we'll definitely have a look at the openerp-usa modules too.
I'm cc'ing Quentin who is currently in charge of our Warehouse R&D
projects (Quentin: see
https://bugs.launchpad.net/openobject-addons/+bug/770243 for the full
discussion).

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/770243

Title:
  Creating 4000+ locations slow down the mrp module installations and
  confirming sale order.

Status in OpenERP Modules (addons):
  Fix Committed

Bug description:
  Hi,
  We imported 4197 locations in openerp. After that installation of mrp modules taking hours and conforming one sale order taking more than one minute. The system is slowing down on the function _product_reserve which is in "bin/addons/stock/stock.py" in class stock_location line 362.

  Sometimes it is throwing the following error
  OperationalError: out of shared memory
  HINT: You might need to increase max_locks_per_transaction.

  The server we are using 6.0.2 stable.
  The locations we used to import is attached with this bug report.

  Please improve the performance of _product_reserve function so that it
  will not hang when the number of locations are in thousands range.

  Thank you.