2016-07-29 9:46 GMT+02:00 Jean CAVALLO <issue_tracker@tryton.org>:

Jean CAVALLO <jean.cavallo@coopengo.com> added the comment:

Agreed. We could also add some warnings if there are possible duplicate
indexes, for instance in your example, the index only on column1 may
not be necessary since the composite index can be used for queries on
column1.

@ Albert :
One question though, I consider that almost all "reverse" fields of O2M
fields should be indexed since every read on the "main" record will
become slow after a time (e.g. account.move->lines). What do you think ?

I agree with Cédric here: it depends. My point is that "thinking" may not bring us anywhere and only analysis will do. And as that depends on the amount of data on each table, it can only happen outside of the module.
 

----------
nosy: +jcavallo

_______________________________________________
Tryton issue tracker <issue_tracker@tryton.org>
<https://bugs.tryton.org/issue5757>
_______________________________________________



--
Albert Cervera i Areny
http://www.NaN-tic.com
Tel. 93 553 18 03