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?
Această întrebare a fost marcată
5296
Vizualizări
Îți place discuția? Nu doar citi, alătură-te!
Creează-ți un cont astăzi pentru a beneficia de funcții exclusive și a interacționa cu minunata noastră comunitate!
Înscrie-te| Postări similare | Răspunsuri | Vizualizări | Activitate | |
|---|---|---|---|---|
|
3
aug. 17
|
7656 | ||
|
0
mai 17
|
8 | ||
|
0
mai 23
|
4120 | ||
|
|
0
feb. 22
|
3022 | ||
|
1
dec. 20
|
7250 |
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+.