Skip to Content
This question has been flagged
updateloadingOdoo13.0odoo13.0moduleupdate
1 Respondre
5764 Vistes
Avatar
syahril asidiq firdaus

Hi everyone, 

i have a problem in my module that has over 600.000 datas in the database.

let's say that i have a field like this and it works well (before update) : 

distance_string = fields.Char(string='Distance', compute='_compute_range')

now i need to update that field to become like this  and : 

distance_string = fields.Char(string='Distance', compute='_compute_range', store=True) outside_range= fields.Selection([('no','no'),('yes','Yes')], string="Out of Range", default='no')

it will also work well if i update in the module that has less data. I think there's no problem with my code. The problem is why do i take so much loading time to update this module and it's never end. Can anyone suggest me how to fix it? because i really need to set store=True in that computed field


nb:  forget bout that stored computed field. this module still take never ends loading even if i just add a new field with the default values. i think the problem is from the how much the datas in my module before i update 

Avatar
Descartar
Avatar
Fady Noor Ilmi Lubis
Best Answer

i know how you feel bro. i was once in your position too.

default values and compute store will give same impact on existing data: update all data to assign the value.

you should try these options:

a. do the update in a system with better computation performance like on the cloud: restore your DB, upgrade the module there, once it finishes backup the DB and restore it back to your local, or

b. change the query into SQL, because ORM is really exhausting your resource and SQL will be much faster

c. upgrade the module to just give the field, use export-import to fill the field for existing data, then add compute to your field with logic "if the field is not empty, than skip for that record". by doing this, your compute field will only taking effect to new datas

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Unable to Download Multiple Invoice at once
update Odoo13.0 pdfreport
Avatar
0
de febr. 22
3538
Where did the type column go from ir_actions_todo?
type Odoo13.0 odoo13.0
Avatar
0
d’abr. 21
3193
Odoo 13 installation won't let me tick the PostgreSQL and 500 internal server error
odoo Odoo13.0 odoo13.0
Avatar
1
de set. 20
6741
Update values of treeview when clic on a button Solved
treeview update Odoo13.0
Avatar
Avatar
1
de gen. 20
7539
TypeError: Cannot read property 'bind' of undefined Solved
Odoo13.0 odoo13.0 odoo13 odoo13CE
Avatar
Avatar
Avatar
5
de set. 21
22768