Community mailing list archives

community@mail.odoo.com

Re: How to increase odoo Performance?

by
Serpent Consulting Services Pvt. Ltd., Jay Vora
- 12/10/2015 12:05:13
Brother,

I meant to avoid browse, search and read methods and use SQL queries directly for pretty quick results.

Believe it or not, the next challenges for any software is data handling and mining. Better indexing and right schema will be the solution.

Thanks,
Regards,
Jay Vora.
Serpent Consulting Services Pvt Ltd.
M : 091-9879354457


-------- Original Message --------
From:Ahmed Elsaka <eng.elsaka09@gmail.com>
Sent:Thu, 10 Dec 2015 21:19:35 +0530
To:Community <community@mail.odoo.com>
Subject:Re: How to increase odoo Performance?

@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

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