Public bug reported:
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.
** Affects: openobject-addons
Importance: Undecided
Status: New
--
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:
New
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.
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
