c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <693833@xxxxxxxxxxxxxxxxxx>]

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.