Odoo performance issues in Amazon Web Services (EC2+RDS)

Question

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.
W

Motez · Accepted Answer

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.

Qutechs, Ahmed M.Elmubarak · Answer

Hi,
which versions ? V9 and 9.5 PG ?
IMHO, it is a PG issue, kindly check this question [1]  also check this thread [2]
For performance tips:
Link1 [3] ,   Link2 [4]
Hope this could helps

[1] https://www.odoo.com/de_DE/forum/hilfe-1/question/reason-why-odoo-being-slow-when-there-is-huge-data-inside-the-database-87498
[2] https://www.odoo.com/de_DE/groups/community-59/community-14262154
[3] http://www.slideshare.net/openobject/performance2014-35689113
[4] http://www.slideshare.net/openobject/ti

August Doo · Answer

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.

Paul John · Answer

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 th

関連投稿	返信	ビュー
Which is the best instance type to use on AWS to deploy ODOO in production? aws ec2 rds	2 11月 24	6140
Odoo Performance Testing 解決済 performance testing	1 10月 22	7145
How can I test OpenERP responsiveness performance benchmark testing	4 2月 19	7567
OpenERP performance as a cloud service performance cloud aws	1 6月 18	8101
Are there any tools for analyzing the Odoo logs? Like having a report based on different events / errors over time. performance logs testing	5 10月 16	9728

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！