c2c-oerpscenario team mailing list archive

Thread
Date

[Bug 648667] Re: 1600 attributes limitation + performance issue

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: "Guewen Baconnier @ Camptocamp" <648667@xxxxxxxxxxxxxxxxxx>
Date: Wed, 10 Nov 2010 09:47:45 -0000
Reply-to: Bug 648667 <648667@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Branch linked: lp:~jgrandguillaume-
c2c/magentoerpconnect/magentoerpconnect_optimized

-- 
1600 attributes limitation + performance issue
https://bugs.launchpad.net/bugs/648667
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in Magento Open ERP Connector: Confirmed

Bug description:
Hello,

As the attributes are managed today (one column per attribute in the product_product table), if the number of Magento's attributes is over 1600, the synchronisation won't work because the number of columns in PostgreSQL is limited to 1600 columns per table.

1600 attributes may seem incredible, but we have a client which is near this limit with ~1400 attributes.

I don't have any solution yet, but I guess that a reflexion should be done.

Thank you
Guewen