Comment 2 for bug 1233153

Revision history for this message
Raphaƫl Valyi - http://www.akretion.com (rvalyi) wrote : Re: [Bug 1233153] Re: Save partner information gets very slow

Hello Marcel,
Could you try to disable the data duplication of the denormalization
process from the company to their contacts?
For instance try to to comment lines 507 and 508 here
https://github.com/akretion/openerp-server/blob/ocb-7.0/openerp/addons/base/res/res_partner.py#L507
restart and report us if this is any faster. This will corrupt the data so
don't use that in production, but that would be interesting to know if the
performance issue comes from the data duplication process.
Thanks for your feedback.

On Mon, Sep 30, 2013 at 10:37 AM, Marcel van der Boom (HS-Development BV) <
<email address hidden>> wrote:

> To clarify a bit:
>
> The problem only occurs when editting the contact information in the
> 'subscreen' of a partner of type company.
>
> --
> You received this bug notification because you are a member of OpenERP
> Drivers, which is subscribed to OpenERP Server.
> https://bugs.launchpad.net/bugs/1233153
>
> Title:
> Save partner information gets very slow
>
> Status in OpenERP Server:
> New
>
> Bug description:
> Version 7.x [bzr] / postgres 9.1 / debian linux
>
> Database has roughly 13.000 partner records.
>
> When editting a partner and modifying one of the contact records of it
> the save operation is very slow (> 60 secs sometimes). When editting
> the partner contact record directly the performance is normal.(< 1
> sec)
>
> I'm at a loss what could cause this, the only thing which is odd is
> that the whole operation seems to play out in 'slow motion' in the
> log. The query log (--log-sql) shows the queries in a slower rate than
> other operations on the same installation.
>
> The save operation completes successfully eventually, even if the
> client has timed out (which is our proxy configuration)
>
> Things checked:
> - all browsers affected
> - there are no slow queries logged (>200ms) by Postgres
> - the load of the application server nor the database server increases
> noticeably
> - moved the whole installation to a local machine (to take out possible
> network errors) -> no difference
> - full vacuum of database makes no difference
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/1233153/+subscriptions
>