c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #12863
[Bug 693833] Re: [6.0] performance issues - stock_move, account_move_lines and others
@Puenednu: there is one problem in your diff, i can not install account.
SyntaxError: keyword argument repeated
** Changed in: openobject-addons
Milestone: None => 6.0
** Changed in: openobject-addons
Status: Fix Committed => Confirmed
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/693833
Title:
[6.0] performance issues - stock_move, account_move_lines and others
Status in OpenObject Addons Modules:
In Progress
Bug description:
1) many analysis reports use a date field to select month,month-1,
year etc
IMHO stock_move and others (account_move_line) will need an index such
a date field.
2) multi_company
IMHO all indices to perform well should be
company_id, field_name
I think there should be no queries without using company_id in the
sql-query.
Suggestion - automatically create indices with company_id + field_name
if company_id exists in the table.
References