Is there any performance tuning guide of tip?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 v15 pos

O tym forum

Pomoc

Is there any performance tuning guide of tip?

performance settings

5 Odpowiedzi

22046 Widoki

Andy Cheng

I have installed openerp v7 on a Intel dual core machine

RAM: 4G
OS: FreeBSD 9.1
PostgreSQL: 9.2

It's a machine for testing OpenERP so there's only 2~3 users.

The reaction is kinda slow even there's only one concurrent user.

The machine's kinda old so I'm trying to squeeze the juice out of it... So I'm wondering does anyone have a tuning guide of tips?

Ray Carnes

Najlepsza odpowiedź

You don't mention the version of PostgreSQL you have installed (9.2 is faster than 9.1), or how much RAM you have, or how many total users you support, how many concurrent users you support, or what they do, or how performance is now - what about those details?

These are the pieces that affect performance of OpenERP:

Disk hardware - very little you can do
Operating System - no experience with FreeBSD
Database - PostgreSQL - see below
Application - Python - Unless you want to start profiling code and re-programming there isn't anything here you can do
Python Interpreter - Doubful there is anything here you can do
Web Server - CherryPy - A single Pentium M 1.6 Ghz with 1GB can support over 500 requests a second
CPU - nothing you can do apart from upgrade
Memory - nothing you can do apart from upgrade/increase

So your only real option is PostgreSQL.

See http://www.slideshare.net/openobject/tips-on-how-to-improve-the-performance-of-your-custom-modules-for-high-volumes-deployment-olivier-dony-open-erp

Andy Cheng

Autor

Thank you!

Andy Cheng

Autor

So actually the only "tuning" we can do is all about Postgre?

Mind And Go

Additionnaly you could find this one : http://fr.slideshare.net/openobject/performance2014-35689113

TECHOPS INFORMATION TECHNOLOGY SOLUTIONS

I know this post is a bit old, but this actually helped me this time.

We had an issue with slow POS orders sync. The config recommendations helped, and especially ensuring AUTOVACUUM is set-up. It was turned off for a while and the DB eventually bloated. 2000% decrease in processing time after completing the process.

Tip: as we are at a "bloated" state, doing a VACUUM takes a lot of time. Our workaround was to export the whole DB, and re-import.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Fiscal localizations settings	2 kwi 25	1418
Where is the "Translated Terms" Menu in Odoo 16? Rozwiązane settings	5 mar 25	17305
Slow Download Speed with Custom Odoo Module performance	0 lut 25	495
setting on v17 ce settings	1 cze 24	1293
I can't open setting Rozwiązane settings	1 maj 24	1006

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!