c2c-oerpscenario team mailing list archive

["qdp \(OpenERP\)" <qdp-launchpad@xxxxxxxxxxx>]

add select=1 on move_id field of account_invoice and of code field of
account_account


** Changed in: openobject-addons
    Milestone: None => 6.0-rc2

-- 
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: Confirmed

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)