Hello,
Added select=1 on both the fields in addons3.
revision-id: m...@mra-laptop-20101116043809-m5fxcb5mj4z62dg9
revno: 4650
Thanks,
mra
** Changed in: openobject-addons
Status: In Progress => Fix Released
--
performance issue account_invoice missing index on move_id
https://bugs.launchpad.net/bugs/571610
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
Status in OpenObject Addons Modules: Fix Released
Bug description:
Example
SELECT l.id, i.id FROM account_move_line l, account_invoice i WHERE l.move_id =
i.move_id AND l.id in
(133695,133694,133691,133690,133689,133688,133687,133686,133685,133684,133683,133682,133681,133680,133679,133678,133675,133674,133673,133672,133698,133697,133696,132344,132343,132342,132341,132340,132339,132338,132337,132336,132335,132334,132333,132332,132331,132330,132329,132328,132327,132326,132325,132324,132323,132322,132321,132320,132319,132316,132315,132314,132313,132312,132311,132310,132309,132308,132307,132306,132305,132304,132303,132302,132301,132383,132382,132278,132277,132276,132275,132273,132272,132271,132270,132269,132268,132267,132266,132265);
WHERE l.move_id = i.move_id will create a full table scan without index.
(do not have enough data to show difference)
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
