Attributes Controller Impossibly Slow

[DigiBooks]

Hi all

We're coming up to 10,000 products online and our Attributes controller is getting sooooo slow!

We've had a few problems today with the host's network causing MYSQL problems which they say have been resolved but it is still very slow trying to add attributes to products.

We will be looking to upgrade to v1.5.4 once we reach the 10K target (will that and the change of MySQL format help cure the problem?) but in the meantime we are struggling (pretty much like watching paint dry!)

Please can anyone suggest how we can speed this process up? We have switched to PHP 5.5 and optimized all the database tables.

Thanks

[RixStix]

Do your attributes require a calculation of price or just a selection?\
If no price calculations are needed, toggle each FUSCHIA attribute button & see if that helps.

[DigiBooks]

Hi

All our products are free downloads as everything is supplied by subscription ... I have tried the attributes controller (but maybe because of host problems today that just wouldn't load) ... Do I have to apply through admin once or every category/subcategory please?)

[DigiBooks]

Just thought can I do an overall database change to switch this attribute off?

[RixStix]

probably could be done globally, but that's above my paygrade.

[DigiBooks]

Bugger LOL!!! Looked at the database table and it's all switched to 1 so I guess needs to be 0 but not sure ho9w to switch it off as standard ,,,,

Will backup database ..... do a table replace then see where we go from there


Thanks

[Design75]

if you go to Catalog => Product Types , select the appropriate product type and then select layout settings.
You will find the default attribute settings at the bottom. These will be set when creating a new product, and will not change the existing one. That will need to be done through phpmyadmin directly in your database.

[mc12345678]

Might be able to help if the "fuchsia field" were more formally identified. Action does not require phpmydmin as could be performed in the tools->install sql patches window.

[mc12345678]

There's also the x next to the category dropdown that when disabled may help assuming many categories are at play.

[Design75]

this is the global patch

UPDATE products_attributes SET attributes_default = '0' WHERE attributes_default = '1'

!!!! BACK UP BEFORE YOU TRY !!!!