Community mailing list archives

community@mail.odoo.com

Re: Slowness, customers

by
Holger Brunn
- 05/12/2015 04:46:38
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

> We have in our database now 8500 invoices. The problem we are
> seeing is slowness in the usage of the system. For example when you
> open some of the larger customers (our largest one has 659
> invoices) it takes several minutes to open.

I made a patch to address this exact issue:
https://github.com/OCA/OCB/pull/220

> Also opening the customer invoices list (for all invoices) is
> getting rather slow. We only have two users so it should not be
> related to concurrency issues.

If you remove the 80 records limit, things get slow fast. If you
actually use this, remove expensive computed fields. But better think
of cases where you use the full list and write a filter that gets you
what you need to know without fetching the whole list

> Are there any known issues here that we should be aware of? Any
> general tricks to analyze performance of Odoo? Cool database
> queries I don't know about?

I wrote a small script to check for bottlenecks on view load, you'll
find it attached. It's quick and dirty, but helps when trying to find
out why loading a specific view takes long

Generally, read
http://www.slideshare.net/openobject/performance2014-35689113

- -- 
Therp - Maatwerk in open ontwikkeling

Holger Brunn - Ontwerp en implementatie

mail: holger@therp.nl
web: http://therp.nl
phone: +31 (0)20 3093096
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iF4EAREIAAYFAlVRve4ACgkQAcl2D+yjrhi+VwEAjTGx/vxW8sJfJPOuVlULQ4Tt
mQJY/XCi0FSYmI/GWTUA/AmhPMLrMXT5bMZ0K5aELxbuKtURCrukwPQLZDNUNFMl
=J7GW
-----END PGP SIGNATURE-----