Community mailing list archives

community@mail.odoo.com

Re: sales order confirmation v9: speed issue

by
Fabien Pinckaers
- 02/01/2016 05:47:41
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