** Branch linked: lp:~openerp-dev/openobject-addons/trunk-dev-addons3 -- 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
