Odoo Server (MOVED TO GITHUB)

  1. Bug #693339
  2. Comment #0

Comment 0 for bug 693339

Revision history for this message
Dukai Gábor (gdukai) wrote : Regression: Huge perfomance decrease with fields.related (5.0)

Hi!

A regression created in <email address hidden>
for v5: http://bazaar.launchpad.net/~openerp/openobject-server/5.0/revision/1950
for v6: http://bazaar.launchpad.net/~openerp/openobject-server/trunk/revision/1844.4.90

If a fields.related with store=True is searched, it doesn't use the stored value but calculates the values like it was not stored at all.
Because of this, for example with a fields.related location_id on stock.picking a search for one location could result in sql queries having 30000 ids instead of a simple stock_picking.location_id in (%s).

There's a stock_location_restict module in the community addons as an example: http://bazaar.launchpad.net/~openerp-community/openobject-addons/trunk-addons-community/annotate/head%3A/stock_location_restrict/stock.py