I've manage a program that syncs data from a program that uses MSSQL to Odoo with rpc. The odoo database has a lot of records and when it updates a record in payment.type it takes a very long time, especially for the most used type. Does the write method update all related records that use the payment type or what can cause the overhead?
La domanda è stata contrassegnata
5373
Visualizzazioni
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!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
3
ago 17
|
7726 | ||
|
0
mag 17
|
8 | ||
|
0
mag 23
|
4186 | ||
|
|
0
feb 22
|
3104 | ||
|
1
dic 20
|
7320 |
Hi, so many answers are possible for such a context.
First of all, which version are you running, what is your odoo.conf content, did you use loglevel as debug, did you log postgresql logs ?
Also precise an estimation of the number of datas you manipulate
The version is odoo 10, the logs (odoo and postgresql) are disabled. The estimation of data is 10k+.