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).
Hi!
A regression created in <email address hidden> bazaar. launchpad. net/~openerp/ openobject- server/ 5.0/revision/ 1950 bazaar. launchpad. net/~openerp/ openobject- server/ trunk/revision/ 1844.4. 90
for v5: http://
for v6: http://
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. location_ id in (%s).
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.
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