Community mailing list archives


Re: How to increase odoo Performance?

- 10/12/2015 10:14:46

For performance improvement it is fine to use SQL queries directly, but if you do so,

What about the security of the Odoo (Access rules and Access rights etc) ?

I guess your suggestion is some how misleading to us.

On Thursday 10 December 2015 08:38 PM, Jay Vora wrote:
<blockquote cite="" type="cite">
For big processes, sadly it has been found that the better idea is to use SQL queries directly.

The use of Queries literally improves the performance 10 times better!(collectively).

On Thu, Dec 10, 2015 at 8:05 PM, Dedi Sinaga <> wrote:

IMHO, from database side, good database design and proper indexing are main factors. From python side, optimize looping process (avoid doing browse or search inside loop).
You may modify your tables by adding indexing and re-check custom addons for looping process.

On Dec 10, 2015 9:07 PM, "Gustavo Orrillo" <> wrote:
get a good DBA who understands PostgreSQL

On Thu, Dec 10, 2015 at 10:29 AM, hamed faheim <> wrote:

Dear All

in the Previous Conversation with Subject” Odoo Hosting Companies

our Conversation Summarized to many of Companies have High Rates as (Digital Ocean, Amazon, Google and LiNode ) and more

The Question Now, How to increase odoo Performance?


From My Point of View, There are many of Factors we should determined them before Buy Server to Increase Performance as;

1- Concurrent User

2- Transactions and inquiries

3- Scheduled Actions

4- Number of Installed modules


Then According to measuring the Above Factors the odoo Implementer Can determine the Server Specifications that work with the Above Factors with High Performance as Memory, CPU, SSD/HD, Band width (this Factors From My Point of View then may be Increase )

now we need to discuss All Factors that depend on odoo Performance to become with High Performance.

Please your recommendation with some Examples (Factors and HD Specifications) .
and I will Start with this Specification:
(4 Cores, 3.40 GHz , RAM: 16 GB, 500 GB SATA) to Implement Odoo for 100 Concurrent Users and default Scheduled Actions and new 3 Scheduled Actions that Run daily/Weekly 

Waiting your Feedback... 


Eng. Hamed Al-Hosiny
Odoo Implementer 

(+20)10 9840 118

Post to:

Post to:

Post to:

The Splendid journey of 2 years in Numbers
Jay Vora
Managing Director

Direct: +91-9879354457
Office: +91-9033472982
Skype: jaynvora
Twitter : jaynvora

Visit our website :
Please consider the environment before printing this email

Post to:


Chirag Rajkotiya,
Odoo/OpenERP Sr. Technical Engineer,
Emipro Technologies Pvt. Ltd.
Rajkot - 360001,India.
Skype  : chirag.emiprotech
Email  :

Find us on Facebook,
For OpenERP/Odoo Videos,

<img src="" alt="Signature"> <img src="" alt="Eminent in all Aspects !">
<img src="" alt="Supporting Paperless Office Concepts !" width="300px" height="50px">

<img src="" alt="Please consider the environment before printing" width="420" height="17">

The information transmitted in this email is directed only to the person to whom it is addressed and may contain confidential and/or privileged material. It should not be read, copied, disclosed or used by any person other than the intended recipient. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is forbidden and may be unlawful. If you received this in error, please contact the sender and delete the material from any digital recovery source or other databases. The contents of this e-mail are the views of the sender and do not necessarily represent the views of Emipro Technologies Pvt. Ltd.