c2c-oerpscenario team mailing list archive

["Bhumika Shrimali \(OpenERP\)" <sbh@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Fix Committed => Fix Released

-- 
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:
  Fix Released

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.