Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
918 Weergaven

when searching in Odoo doc ,I found that: 

Imagine 2 models A and B

if B has a related field from A like A.age ,why does odoo store in the B.age the link to A.age not the actual value . the link costs more memory than the actual value 

Avatar
Annuleer
Beste antwoord

Hi,


* A related field in Odoo does not store a “link” in memory in the same sense as a pointer or reference object.


* The related field behaves like a computed field that pulls its value on demand from the source model (A.age in your example).


* Unless you set store=True, Odoo does not persist the value in the database table of model B, it computes it every time it's accessed.


* The data type remains the same as the source field (bool, int, etc.), not a reference or pointer type.


* When you use store=True,

      - Odoo creates a column in model_b's table to store the value.

      - It’s synced automatically using compute triggers (depends).

      - Now it does use memory/storage, but stores the value directly as int, not a reference.



Hope it helps



Avatar
Annuleer
Beste antwoord

It's related so there must be a link somewhere in case the record get updated. Depending on the type of data, the link would not necessarily be more memory expensive compared to the value: such as an image, a big html content. My wife used to write her meeting schedule on a postit and put it on the fridge as reminder and she doesn't want to listening to my lecturing on single version of truth only to find out sometimes the meetings are rescheduled and she misses them. In ERP systems like Odoo, data consitency is of crucial values compared to be economical saving a few kb here and there.

Avatar
Annuleer
Auteur

Thanks for clarification ,but the question if I have a bool or Int value ,Is storing links more memory expensive and that means that the data type of related fields is something else rather than the actual value type ?

Gerelateerde posts Antwoorden Weergaven Activiteit
5
mei 24
13814
1
feb. 24
2255
7
jul. 16
6140
0
jun. 24
1452
3
feb. 21
16725