c2c-oerpscenario team mailing list archive

["Purnendu Singh \(OpenERP\)" <psi@xxxxxxxxxxxxx>]

Hello,

We have fixed the problem in lp:~openerp-commiter/openobject-addons
/trunk-dev-addons3-psi2

Revision no: 4618
Revision ID: psi@xxxxxxxxxxxxx-20110117112056-ryw0wyjltqzeuhzt

Thanks for reporting.


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

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

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.