[6.0] performance issues - stock_move, account_move_lines and others

[Ferdinand]

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.

[Ferdinand (office-chricar)]

if the company_id field is not mandatory may be a better index is (field_name,company_id)

[Ferdinand (office-chricar)]

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

[Vinay Rana (OpenERP) (vra-openerp)]

We Let the Addons2 team decide.

Thanks.

[Rifakat Husen (OpenERP) (rha-openerp)]

Hello,

It has been fixed in lp:~openerp-commiter/openobject-addons/dev-addons2-rha1
with
Revision ID: <email address hidden>
and
Revision no: 4483

Thanks for reporting.

[Purnendu Singh (OpenERP) (purnendu-singh)]

Hello,

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

Revision no: 4618
Revision ID: <email address hidden>

Thanks for reporting.

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

@Puenednu: there is one problem in your diff, i can not install account.

SyntaxError: keyword argument repeated

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

it is working fine now Addons3 with your latest merge.

I have merged it in addons3 with:
revision-id: mra@mra-laptop-20110117123659-t3etytigbjtd88uq

thanks,
mra

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

I request Addons1 team to check for related changes.

thanks
mra

[Jigar A. (ifixthat)]

Hello,
       Fixes from add-ons modules have been done and committed to the lp:~openerp-dev/openobject-addons/jam-dev-addons.
       Revision No : 4046
Thank You