Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
performanceawstestingec2rds
4 Odpowiedzi
16769 Widoki
Awatar
Carlos DuAl

Hello all, 

I'm currently testing odoo deployment in amazon web services. I have odoo installed in a ec2 instance and the database (Postgres) in a rds instance.

I'm starting the tests with the free-tier instances

ec2 - 1 CPU - 1GB Ram
rds - 1 CPU- 1GB Ram
Launching a test that confirms 800 invoices takes me around 8-9 minutes to complete

I'm assuming that the bottleneck is caused by the database, since the ec2 instance only has odoo which doesn't do the actual heavy-lifting in the requests.

When I upgrade the rds instance to 2 CPUs and 8 GB of Ram I can see a slight increase in performance, the same test now takes around 6 minutes to complete.

However, when I upgrade the rds instance to 16 CPUs and 122 GB of Ram the increase is almost unnoticeable compared with the previous setting, it takes around 5 minutes 30 seconds. 

Is the internal structure of Postgres not taking advantage of the extra CPU and Ram?

We are planning to implement our intranet with Odoo and we're looking at at least 50 concurrent conections at any given time, would the ec2 instance with 1CPU and 1GB of ram , with the rds instance of 2CPUs and 8GB of RAM be enough for that? 


Is there any way to increase Odoo's performance? Replicating databases might help with concurrent access but I'm not sure it's possible with Odoo+Postgres, should we use other databases?


Awatar
Odrzuć
Awatar
Motez
Najlepsza odpowiedź

The hardware you used is far beyond the recommended one so it should be more than sufficient. If you add CPUs you need to enable multi processing mode in order for odoo to make benefice of extra ones. Try running your server with the option --workers=12 and let's see how it goes for performance. 

Awatar
Odrzuć
Awatar
Qutechs, Ahmed M.Elmubarak
Najlepsza odpowiedź

Hi,

which versions ? V9 and 9.5 PG ?

IMHO, it is a PG issue, kindly check this question also check this thread 

For performance tips:

Link1,  Link2 

Hope this could helps

Awatar
Odrzuć
Awatar
August Doo
Najlepsza odpowiedź

Thanks Carlos for your great trial since I'm looking from something similar with this. Although I didn't test it, I can feel it is much slower when installing Odoo 9 onto T2.micro than T2.small with database on the same server. 

Awatar
Odrzuć
Awatar
Paul John
Najlepsza odpowiedź

Understanding the needs of ecommerce business and to help them get necessary configurations and architecture. www.cloudways.com/blog/aws-for-ecommerce-applications/ platform provides its users with ready-to-use ecommerce architecture and blueprints in the form of AWS Cloud formation templates. These templates are provisioned to highly scalable and available infrastructure for hosting online stores.

Ecommerce web apps and platform providers such as Magento have noticeably published versions of their software to finetune to AWS architecture and integrate AWS monitoring and security processes.


Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
Which is the best instance type to use on AWS to deploy ODOO in production?
aws ec2 rds
Awatar
Awatar
Awatar
2
lis 24
6107
Odoo Performance Testing Rozwiązane
performance testing
Awatar
Awatar
1
paź 22
7112
How can I test OpenERP responsiveness
performance benchmark testing
Awatar
Awatar
Awatar
Awatar
4
lut 19
7544
OpenERP performance as a cloud service
performance cloud aws
Awatar
Awatar
1
cze 18
8091
Are there any tools for analyzing the Odoo logs? Like having a report based on different events / errors over time.
performance logs testing
Awatar
Awatar
Awatar
Awatar
5
paź 16
9714