Hello!
Did you ever find yourself to be in a place where you got an external module to work but it is taking way too much of time to activate / or get installed?
what to do in this situation ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
Hi,
If the module is adding any stored compute field to any of the existing model, which has a huge data, this issue will be happening, it is the time taken for computing and storing the value.
To confirm if this is what happening with you, you can check and see the odoo log, it will be something like "Storing value............" in the log.
In order to speed up this, you have to add the field to the db table from the auto_init and set the needed value for the field.
Example:
def _auto_init(self):
"""
Create column to stop ORM from computing it himself (too slow)
"""
if not column_exists(self.env.cr, 'sale_order_line', 'is_service'):
create_column(self.env.cr, 'sale_order_line', 'is_service', 'bool')
self.env.cr.execute("""
UPDATE sale_order_line line
SET is_service = (pt.type = 'service')
FROM product_product pp
LEFT JOIN product_template pt ON pt.id = pp.product_tmpl_id
WHERE pp.id = line.product_id
""")
return super()._auto_init()
Thanks
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
RegistratiPost correlati | Risposte | Visualizzazioni | Attività | |
---|---|---|---|---|
|
2
lug 20
|
3770 | ||
|
1
gen 20
|
2200 | ||
Creating module problem
Risolto
|
|
1
dic 19
|
3126 | |
|
0
feb 16
|
3706 | ||
|
2
mar 15
|
7907 |