Community mailing list archives

community@mail.odoo.com

Re: v8 / v9 performance test

by
Andi Becker
- 11/07/2015 18:44:14
well Zahid

we are running one instance on DigitalOcean for doing some tests

This was this morning - during the night nobody was working on the site!

The 512MB Droplet was not sufficient as we had memory problems
We increased to the 1GB Droplet and even here it seems it is running full.
top - 18:24:07 up 1 day, 11:21,  1 user,  load average: 0.00, 0.03, 0.11
Tasks:  94 total,   2 running,  92 sleeping,   0 stopped,   0 zombie
%Cpu(s):  1.0 us,  0.3 sy,  0.0 ni, 98.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   903048 used,   114824 free,    31492 buffers
KiB Swap:        0 total,        0 used,        0 free.   488800 cached Mem

I just restarted the ODOO Server new

top - 18:25:00 up 1 day, 11:22,  1 user,  load average: 0.00, 0.03, 0.11
Tasks:  75 total,   2 running,  73 sleeping,   0 stopped,   0 zombie
%Cpu(s):  1.3 us,  1.0 sy,  0.0 ni, 97.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   685688 used,   332184 free,    38672 buffers
KiB Swap:        0 total,        0 used,        0 free.   507132 cached Mem

I now rebooted the complete droplet - just after reboot before the odoo-server started

top - 18:26:49 up 1 min,  1 user,  load average: 0.12, 0.04, 0.02
Tasks:  77 total,   1 running,  76 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.0 us,  0.3 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   224896 used,   792976 free,    23792 buffers
KiB Swap:        0 total,        0 used,        0 free.    95948 cached Mem

Now the Odoo server is started too in the rebooted droplet

top - 18:28:13 up 2 min,  1 user,  load average: 0.23, 0.08, 0.03
Tasks:  82 total,   1 running,  81 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.0 us,  0.3 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   351180 used,   666692 free,    32528 buffers
KiB Swap:        0 total,        0 used,        0 free.   140832 cached Mem

We called the frontpage of our Odoo site the second time

top - 18:29:19 up 3 min,  1 user,  load average: 0.12, 0.08, 0.04
Tasks:  82 total,   1 running,  81 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.3 us,  0.0 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   374136 used,   643736 free,    32768 buffers
KiB Swap:        0 total,        0 used,        0 free.   149908 cached Mem

We called reloaded the same Odoo frontpage again

top - 18:30:56 up 5 min,  1 user,  load average: 0.02, 0.06, 0.04
Tasks:  80 total,   2 running,  78 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.0 us,  0.3 sy,  0.0 ni, 99.3 id,  0.3 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   380396 used,   637476 free,    32856 buffers
KiB Swap:        0 total,        0 used,        0 free.   149928 cached Mem

and we reloaded it a fourth time - only pressing the reload button

top - 18:31:53 up 6 min,  1 user,  load average: 0.01, 0.05, 0.04
Tasks:  80 total,   2 running,  78 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.3 us,  0.0 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   381428 used,   636444 free,    32888 buffers
KiB Swap:        0 total,        0 used,        0 free.   149936 cached Mem

We call the apps page in the backend

top - 18:33:05 up 7 min,  1 user,  load average: 0.00, 0.04, 0.04
Tasks:  81 total,   2 running,  79 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.3 us,  0.0 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   410116 used,   607756 free,    33512 buffers
KiB Swap:        0 total,        0 used,        0 free.   161204 cached Mem

we activate developer mode on the apps page

top - 18:34:05 up 8 min,  1 user,  load average: 0.00, 0.03, 0.04
Tasks:  81 total,   2 running,  79 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.7 us,  0.0 sy,  0.0 ni, 99.0 id,  0.3 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   413480 used,   604392 free,    33920 buffers
KiB Swap:        0 total,        0 used,        0 free.   165612 cached Mem

switching back to the frontend - website

top - 18:34:38 up 8 min,  1 user,  load average: 0.08, 0.05, 0.04
Tasks:  81 total,   2 running,  79 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.0 us,  0.3 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem:   1017872 total,   420792 used,   597080 free,    33944 buffers
KiB Swap:        0 total,        0 used,        0 free.   166428 cached Mem

...
...
If you now start working with something in Odoo the used memory will grow up to nearly 1GB as see this morning (actually this morning it was low in comparison to other days.)

---

How are those values if you are doing the steps on your computer.

---

The frontend performance of the website module is bad if you don't have an proxy
we use i.e. cloudflare. 
as soon as you switch cloudflare to on the website will perform with brilliant values - pagespeed about 98%-99% yslow about 95%-97%

Those values are with optimised images! 

If you use the Odoo optimisation it is only little below those values.

---

But it seems the backend consumes a lot of energy and it is getting slow the longer you are using it and even the loading of the complete backend will fail and css or other parts don't get loaded.

---

On that droplet is running only a very simple Ubuntu 14.04 image + the yenthe install script Odoo - but with Postgres 9.4 usage. - Nothing else is running here!

Fazit: ODOO is very very hungry!

I think it is not Postgres but it is ODOO itself which is causing those problems. Since years already people complained about the way memory gets used in ODOO and it seems that it does not get freed again after usage if it is no more used!

---

How are those values on 9.3 Postgres?

By the way we run ODOO 9!




Above is this morning even during the night nothing happened on the site and 


With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
Cordialement,
с сердечным приветом,
เรื่องที่เกี่ยวกับชนิด,
與親切的問候,

 

ANDI BECKER

CEO/General Manager LisAndi Co., Ltd.

--------------------------------------------------

LisAndi Co. Ltd., Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

Mobile: +66 (0)81 606 3378
VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk:  andi@lisandi.com
Facetime:      andi@lisandi.com


--------------------------------------------------

This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Sun, Nov 8, 2015 at 12:07 AM, zahid jalal <j.zahid@gmail.com> wrote:
Hi community
I have a couple of questions about odoo server perfs
1- Has any one did some performance testing comparaison between v8 / v9.  ( data loading time, smoothness of the interface )
2- Even if odoo does not use advanced postgresql features that has been strongly improved in v 9.4. Does migration to postgresql 9.4 impacts performances ?





SSLL, Intégrateur Odoo.
Intégration de Services.
BI and IT consulting.
j.zahid@auriumtechnologies.com
tél  0661360233 - 0636898882
fax 0528215738

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