Sign in
Try it free
  1. Mailing Lists
  2. Community
  3. Re: How to increase odoo Performance?

Community mailing list archives

community@mail.odoo.com

Browse archives

Re: How to increase odoo Performance?

Re: How to increase odoo Performance?

Re: How to increase odoo Performance?

by
Ahmed Shaaban
- 12/10/2015 10:14:53

@Jay,

Could you Please share these queries?

Regards,
Ahmed Elsaka

On 10 Dec 2015 17:10, "Jay Vora" <vora.jay@serpentcs.com> wrote:
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 <dedisinaga@gmail.com> 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" <gustavo.orrillo@moldeointeractive.com.ar> wrote:
get a good DBA who understands PostgreSQL

On Thu, Dec 10, 2015 at 10:29 AM, hamed faheim <eng_hamed@hotmail.com> 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... 


 
Sincerely, 

Eng. Hamed Al-Hosiny
Odoo Implementer 

Mobile: (+20)10 9840 118
E-mail : eng_hamed@hotmail.com


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




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


 
Direct: +91-9879354457
Office: +91-9033472982
Skype: jaynvora
Twitter : jaynvora
   
-------------------------------------------------------------------------------------------------
Visit our website : http://www.serpentcs.com
Please consider the environment before printing this email

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

Reference