c2c-oerpscenario team mailing list archive

["AMP\(OpenERP\)" <amp@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: New => Triaged

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

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.