Message 27456

Author
albertca
Date
2016-07-29.17:07:19
Message id
27456

Content

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

Files

File name Uploaded Type Details
unnamed albertca, 2016-07-29.17:07:18 text/plain view
History
Date User Action Args
2016-07-29 17:07:19albertcasetrecipients: + jcavallo
2016-07-29 17:07:19albertcalinkissue5757 messages
2016-07-29 17:07:19albertcacreate

Showing 10 items. Show all history (warning: this could be VERY long)