Community mailing list archives
Re: sales order confirmation v9: speed issueby
Mit freundlichen Grüßen
axxelia GmbH & Co. KG
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 <firstname.lastname@example.org>: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.--FabienOn Mon, Feb 1, 2016 at 8:57 AM, OpenERP Master <email@example.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 <firstname.lastname@example.org> wrote:2016-02-01 1:36 GMT-06:00 OpenERP Master <email@example.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.