c2c-oerpscenario team mailing list archive

["Rifakat Haradwala \(OpenERP\)" <693833@xxxxxxxxxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Triaged => In Progress

-- 
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.