Too many attributes? Store too slow

[rliddle]

Lat9, Can I just say, Thank You, Thank you!! I implemented that on one of my products and went from

Parse Time: 8.386 - Number of Queries: 1665 - Query Time: 7.37952516934

to

Parse Time: 0.671 - Number of Queries: 178 - Query Time: 0.194840832687

Amazing! I hope others who are in similar situations find this thread. I talked with "experts" in Seattle, Van Couver, Penn, Va, and switched hosts 2 times and this is the solution!

Thanks everyone for your help. Moving on!

[dgent]

Make sure that each of your attributes are marked with "Apply Discounts Used by Product Special/Sale: No" (assuming that the options don't have cost associated with them); this will heavily reduce your parse times.

Will this make any difference to a site that has attributes with costs applied to them, but it not using any sales discounts on any products?

If it does, what sql patch would I need to run to turn every attribute I have to 'no' ?

[Ajeh]

If you have no Sales or Specials or do not offer those same Specials and Sales on Attributes then you can turn it off for all Attributes with:

UPDATE  products_attributes SET attributes_discounted = 0;

[rliddle]

Ajeh, can you tell me specifically where this code would go? thanks.

Excellent idea ... a fast way to do this for Attributes with 0 price that would not need the discount checked is to use:

UPDATE  products_attributes SET attributes_discounted = 0 WHERE options_values_price = 0;

[lat9]

Lat9, Can I just say, Thank You, Thank you!! ...

Thanks everyone for your help. Moving on!

You are very welcome! Perhaps this pointer should be part of one of the attributes-related tutorials.

[Ajeh]

Ajeh, can you tell me specifically where this code would go? thanks.

You can run that in phpMyAdmin on the SQL or in the Tools ... Install SQL Patches ...

[DrByte]

Gads - I completely missed those attribute things.
Grateful for the others who stepped in with the settings tweaks.

And ... the side-benefit is that you've now done a heckuvalotta tuning for server performance overall. :)

[eastwin]

Hi all,

I am having a similar problem - products with attributes are loading very slowly. We sell invitations, which are very customized so attributes are a big part of our business.

You can check out my sample product here:
http://sweetletterpress.com/2013/ind...ndex&cPath=104
with parse/query time shown at the bottom.
(I still have to add more attributes under "font 1" and "font 2" and I haven't added the additional product images yet either, all of which I'm assuming will slow it down even more)

Even slower than the product details page is the "quick view" (which should be called "very slow view"!). You can access it from the same link above by rolling over the thumbnail. Any thoughts on how to simplify/speed up this up?

I have an experienced ZC developer helping me but he says he's done all that he knows how for speed. We are using the latest version of zenCart on shared Hostmonster plan and a substantial number of customizations made to the install.

I am on hold with my hosting company right now to have them examine the things you all mentioned in this thread but I am hoping some of you Zen masters will take a look and see if anything looks amiss... extraneous, bloated code, errors etc.

Thanks very much.

[eastwin]

UPDATE

Hostmonster says usage is all fine and normal. He upgraded me to php 5.3 (from 5.2) but not noticing any difference.

[DrByte]

The times I'm seeing are:
http://sweetletterpress.com/2013/ind...ndex&cPath=104
Parse Time: 4.625 - Number of Queries: 125 - Query Time: 3.1653004515839
Parse Time: 0.209 - Number of Queries: 114 - Query Time: 0.037671459594726
Parse Time: 0.255 - Number of Queries: 114 - Query Time: 0.083213655319214

Quick view:
Parse Time: 7.439 - Number of Queries: 184 - Query Time: 3.3798476817322
Parse Time: 4.684 - Number of Queries: 184 - Query Time: 1.4276787158661
Parse Time: 6.825 - Number of Queries: 184 - Query Time: 2.1082679089355
Parse Time: 5.672 - Number of Queries: 184 - Query Time: 2.7163698864136

http://sweetletterpress.com/2013/wed...ing-invitation
Parse Time: 12.044 - Number of Queries: 245 - Query Time: 4.2742161156921
Parse Time: 9.282 - Number of Queries: 245 - Query Time: 3.6378543113098
Parse Time: 13.134 - Number of Queries: 245 - Query Time: 5.9804625470123
Parse Time: 8.659 - Number of Queries: 245 - Query Time: 3.6243100138245

So it looks like you've got slowness happening at both the database side and the CPU/PHP processing side.
With your many customizations and AJAX additions, I'm inclined to think those may be big culprits.



Some things for your developer to address:
1. You've got some assets that your template is trying to load, but which do not exist, including the main jQuery file and a .gif image, etc:
GET http://sweetletterpress.com/2013/inc...y-1.4.4.min.js 404 (Not Found)

Uncaught TypeError: Object [object Object] has no method 'fancybox'

GET http://sweetletterpress.com/2013/inc.../tableft28.gif 404 (Not Found)

2. You're loading 4 different versions of jQuery on your site. That's a HUGE performance problem, plus it also creates chaos for your page scripts to try to figure out what they're doing:
/2013/includes/templates/theme219/jscript/jquery-1.4.4.min.js
/2013/includes/templates/theme219/jscript/jscript_jquery-1.5.min.js
/2013/includes/modules/pages/product_info/jscript_jquery-1.5.2.min.js
/2013/includes/templates/theme219/jscript/jscript_jquery-1.8.2.min.js
Each of those files take 0.7 to 1.3 seconds to load, and only the newest one is really needed. The others should be deleted.

3. Plus you're calling /2013/dpu_ajax.php to set the price on the page, and each time it fires it's taking 2.11 seconds to run. So whatever it's doing in the background needs some optimization too.

Fixing those issues will probably provide some reprive, and then maybe make other fixes more evident.