2010-12-22 11:24:18 |
Dukai Gábor |
bug |
|
|
added bug |
2010-12-22 11:24:43 |
Dukai Gábor |
summary |
Regression: Huge perfomance decrease with fields.related (5.0) |
Regression: Huge perfomance decrease with fields.related (v5 and v6) |
|
2010-12-22 11:24:50 |
Dukai Gábor |
summary |
Regression: Huge perfomance decrease with fields.related (v5 and v6) |
Regression: Huge performance decrease with fields.related (v5 and v6) |
|
2010-12-22 11:25:28 |
Dukai Gábor |
branch linked |
|
lp:openobject-server/5.0 |
|
2010-12-22 11:25:44 |
Dukai Gábor |
branch linked |
|
lp:openobject-server |
|
2010-12-22 11:27:37 |
Dukai Gábor |
description |
Hi!
A regression created in jvo@tinyerp.com-20100202150454-x9kne83yzkjciidw
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 |
Hi!
A regression created in jvo@tinyerp.com-20100202150454-x9kne83yzkjciidw
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_resrtict 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
|
|
2010-12-22 11:27:50 |
Dukai Gábor |
description |
Hi!
A regression created in jvo@tinyerp.com-20100202150454-x9kne83yzkjciidw
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_resrtict 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
|
Hi!
A regression created in jvo@tinyerp.com-20100202150454-x9kne83yzkjciidw
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_restrict 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
|
|
2010-12-23 12:23:58 |
Vinay Rana (OpenERP) |
openobject-server: status |
New |
Triaged |
|
2010-12-23 12:23:58 |
Vinay Rana (OpenERP) |
openobject-server: assignee |
|
OpenERP's Framework R&D (openerp-dev-framework) |
|
2010-12-23 15:07:59 |
Olivier Dony (Odoo) |
openobject-server: importance |
Undecided |
Medium |
|
2010-12-23 15:07:59 |
Olivier Dony (Odoo) |
openobject-server: status |
Triaged |
Fix Released |
|
2010-12-23 15:07:59 |
Olivier Dony (Odoo) |
openobject-server: milestone |
|
6.0-rc2 |
|
2010-12-23 15:08:17 |
Olivier Dony (Odoo) |
nominated for series |
|
openobject-server/5.0 |
|
2010-12-23 15:08:17 |
Olivier Dony (Odoo) |
bug task added |
|
openobject-server/5.0 |
|
2010-12-23 15:08:39 |
Olivier Dony (Odoo) |
openobject-server/5.0: importance |
Undecided |
Medium |
|
2010-12-23 15:08:39 |
Olivier Dony (Odoo) |
openobject-server/5.0: status |
New |
Confirmed |
|
2010-12-23 15:08:39 |
Olivier Dony (Odoo) |
openobject-server/5.0: milestone |
|
5.0.16 |
|
2010-12-23 15:08:39 |
Olivier Dony (Odoo) |
openobject-server/5.0: assignee |
|
Jay (OpenERP) (jvo-openerp) |
|
2010-12-23 15:08:59 |
Olivier Dony (Odoo) |
tags |
|
maintenance |
|
2010-12-23 18:32:32 |
Jay Vora (Serpent Consulting Services) |
openobject-server/5.0: status |
Confirmed |
Fix Released |
|
2010-12-23 18:32:57 |
Jay Vora (Serpent Consulting Services) |
summary |
Regression: Huge performance decrease with fields.related (v5 and v6) |
Regression: Huge performance decrease with fields.related with store=True/{}(v5 and v6) |
|