Attributes Controller Impossibly Slow

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

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.

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?)

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

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

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

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.

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.

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

this is the global patch

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

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

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.

Yes, I specifically meant the "DISCOUNTED" button which is fuschia on my screens but I was using my WindowsRT computer in the production facility and that version of Internet Explorer does not play nice at all with this particular forum.

Fuschia = recalculate and use server resources.
"X" = OFF calculations not needed.

Design75:

this is the global patch

UPDATE products_attributes SET attributes_[B]discounted[/B] = '0' WHERE attributes_[B]discounted[/B] = '1'

> !!!! BACK UP BEFORE YOU TRY !!!!
Corrected above... 

> **RixStix:**
>
> Yes, I specifically meant the "DISCOUNTED" button which is fuschia on my screens but I was using my WindowsRT computer in the production facility and that version of Internet Explorer does not play nice at all with this particular forum.
> 
> Fuschia = recalculate and use server resources.
> "X" = OFF      calculations not needed.

Default is orange... (In a default ZC store)

Thanks as always guys.

Gonna take a deep breath, cook and eat the take another look at it ... Out host has caused so many problems today that I'm tearing my hair out! Attributes have always had a habit of being intermittenly SLOW so just looking for the best soution

mc12345678:

Corrected above...

Default is orange... (In a default ZC store)

:blush: sorry, I knew that. I copied the wrong field.

Ok Ran this :

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

and all seems OK ... still cannot see where to switch it off site-wise. Can anyone login and take a look please?

Thank you

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.

Already told you here:smile:

Two things... One, am I correct that as far as attributes, that you basically have one option name with one option value allowing the filename of the file(s) to be associated or have you created one option name for each product? (Considering that this is all about downloads)...

The other thing, and I can't believe I didn't think about it, but EasyPopulate v4 offers attribute addition, modification, and removal including handling reference to file downloads...

Design75:

Already told you here:smile:

Sorry mate ... head in a spin because of other personal issues .... will take a breather and review :)

DigiBooks:

Sorry mate ... head in a spin because of other personal issues .... will take a breather and review :)

No problem, it happens :smile: