Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
857 Widoki

Our database is currently facing an issue where the CPU usage reaches almost 100% every day during the daily operations. For your information, we have hosted the Odoo apps on Amazon Web Services and are using version 14 of Odoo.

We analyzed using performance insight AWS where there are some slow queries in odoo as the below
"SELECT "account_move".id FROM "account_move" WHERE ("account_move"."reversed_entry_id" in (?)) ORDER BY "account_move"."date" DESC,"account_move"."name" DESC,"account_move"."id" DESC"

As we know, the above query is default in Odoo and wasn't customized by our developer. My question is:
1. Have your customers ever had the same experience as us?
2. can you give me some advice so that this issue does not happen again in the future?
3. Could you please provide me with some advice on how to optimize the performance of an Odoo database, based on your experience?


Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
cze 25
1332
0
maj 25
12
2
sty 25
2859
1
gru 24
6558
1
lis 24
2954