c2c-oerpscenario team mailing list archive

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

reading this it might not be necessary to have include company_id 
http://www.postgresql.org/docs/8.4/interactive/indexes-bitmap-scans.html

nevertheless anylsys reports tend do do full table scans 
hence for very big tables (20.000 records in account_move_line use 0.1  second) 
* auto search should be turned off
* a reasonable default filter should be set and the query plan must be examinend

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