Community mailing list archives

community@mail.odoo.com

Re: sales order confirmation v9: speed issue

by
Axxelia GmbH & Co.KG, Markus Menner
- 02/01/2016 06:14:48
If I’m right it’s f0646cb =>  [IMP] fields: use a "lazy" cursor to compute attribute `digits`     

Mit freundlichen Grüßen
Markus Menner

 


axxelia GmbH & Co. KG
Herrenstraße 45, 79098 Freiburg
Telefon: +49 (0)761 205514-00
Telefax: +49 (0)761 205514-10
Mobil: +49 (0)1520 4144440
Sitz der Gesellschaft: Freiburg 
Amtsgericht Freiburg HRA 703295

Persönlich haftende Gesellschafterin: 
axxelia Verwaltungs GmbH
Herrenstraße 45, 79098 Freiburg
Sitz der Gesellschaft: Freiburg
Amtsgericht Freiburg HRB 709896 
Geschäftsführer: Markus Menner


Confidentiality: This e-mail and any attachments are confidential and may also be privileged. They are intended solely for the recipient’s use. If you are not the named recipient please notify the sender immediately and do not disclose the contents to another person, do not use it for any purpose or store or copy the information in any medium. 


Vertraulichkeit: Diese e-Mail sowie alle Anhänge sind vertraulich. Sie sind allein für den angegebenen Empfänger bestimmt. Wenn Sie nicht der angegebene Empfänger sind, informieren Sie bitte umgehend den Versender und geben Sie den Inhalt gegenüber keiner anderen Person preis, benutzen Sie die Mail nicht für andere Zwecke und speichern oder kopieren Sie die hier enthaltenen Informationen nicht auf irgendeinem Datenträger.





Am 01.02.2016 um 12:03 schrieb Fabien Pinckaers <fp@odoo.com>:

Details about the two latest performance issues:

1) The main issue was after gathering data from the DB with float field. They were always rounded in convert_to_cache even if it comes from the DB (validated = False). The problem is the round function asks for a new cursor and when there are a lot of floats (i.e., while prefetching), that is an issue. (# lines * nbr floats in table since all floats are prefetched). The fix, was to skip the rounding when it comes from the database using a lazy cursor (v8) and a better implementation (master).

2) Also, we improved the request in _product_available with a cr.execute in order to reduce the time of the function from 1s/1K products (after convert_to_cache improvement) to 0.01s/1K products.


I don't have the rev number here, but search LazyCursor in recent commits, in both v8 and v9.



-- 
Fabien


On Mon, Feb 1, 2016 at 8:57 AM, OpenERP Master <openerpmaster@gmail.com> wrote:
Were you referring to my post? Dont get your response. I was not asking about how upgrading postgres will improve performance, but more interested to learn about the changes Fabien mentioned were committed.

On Mon, Feb 1, 2016 at 1:42 AM, Nhomar Hernández <nhomar@gmail.com> wrote:

2016-02-01 1:36 GMT-06:00 OpenERP Master <openerpmaster@gmail.com>:
Why is there no references posted here for verification, such as a link to the commit, or an explanation of what was done to improve the performance.

I have 3 days whitout sleep testing 4 big databases..... I do not want to know how odoo itself is on their side...

enought reason?

It will tell you A LOT. a little google do not harm anybody.


--
--------------------
Saludos Cordiales

CEO at Vauxoo Odoo's Gold Partner.
 
--
Nhomar Hernandez
 

_______________________________________________
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