Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
4172 Visualizzazioni

Recently we needed to delete a custom related field, as it was slowing down Odoo to the point of the system being unusable.  

What do we need to consider when creating related fields via the UI?

Avatar
Abbandona
Risposta migliore

Match the data type of the field you create to the field you are relating to.  Don't create a Float related to an Int, for example.

Never create a related field based on (has a dependency of) a field that itself is related or computed. 

If you don't need to store the value, don't. 

Adding a stored related field on table where you already have thousands of records may not be possible, as values for all existing records need to be computed first, and you may get a timeout.

Make sure to avoid circular dependencies.


Review https://www.odoo.com/documentation/12.0/reference/orm.html#related-fields

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
5
ago 24
3100
2
apr 23
6345
0
gen 22
2657
1
mar 25
4643
1
set 21
6315