c2c-oerpscenario team mailing list archive

[Mile Infokom <683127@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hi!

I have a problem with saving product (it is more than 1min long). I've found out that it is due to pricelists. I have more than 3000 pricelists and more than 15000 items in pricelists. Products and pricelists are connected through ir_property table in database and i have more than 5000 records in it (for sale and purchase pricelists and some sale pricelists are shared with multiple partners).
If I delete everything from pricelists in database, saving is done immediately (less than 1 sec). I think that it should work ok even with this amount of data and I suppose that it can be fixed by custom indexes?
And another question is: why is saving product doing anything with pricelists? Is it checking margins or something?

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
product save
https://bugs.launchpad.net/bugs/683127
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: New

Bug description:
Hi!

I have a problem with saving product (it is more than 1min long). I've found out that it is due to pricelists. I have more than 3000 pricelists and more than 15000 items in pricelists. Products and pricelists are connected through ir_property table in database and i have more than 5000 records in it (for sale and purchase pricelists and some sale pricelists are shared with multiple partners).
If I delete everything from pricelists in database, saving is done immediately (less than 1 sec). I think that it should work ok even with this amount of data and I suppose that it can be fixed by custom indexes?
And another question is: why is saving product doing anything with pricelists? Is it checking margins or something?