zen cart for contact lenses?

[thedjphat]

Hi again folks.

I'm now about 3 weeks into setting up a zen cart 1.3.9h installation to sell contact lenses at http://opticalnow.ca

I've managed to get everything set up the way it's needed, but now I have issues with parse time and requests, I'm guessing due to the huge amount of attributes that have to be pulled from the DB before the pages can be displayed.

Contact Lenses are pretty specific, product wise. I've arranged the attributes in two sets to account for selling left and right pairs, using flexible attributes to define the layout.

The Sets of attributes contain values for the following variables:

BC / DIA
Power Range
Adds (if any)
Axis (if any)
Cyl (if any)
Quantity (as a price factor)
Base Price (as a hidden base attribute)

On average, each product has between 80-120 attributes to display on a product page, and most products have a set of attributes that are unique.

I've disabled everything I can find to improve product load speeds, optimized the database, and even removed some javascript. It seems like the cart is trying to do too many queries per product page.

This page for example has a ridiculous load speed.

Parse Time: 17.119 - Number of Queries: 4948 - Query Time: 10.224817272491

HALP!

[kobra]

You will never get great times at GD

[thedjphat]

I get great load times on pages such as categories, the home page, defined pages. What I don't understand is why, on a product page, do my queries to the database seem to inflate exponentially?

These I can live with.
Parse Time: 1.089 - Number of Queries: 185 - Query Time: 0.18311192378235 (home page)
Parse Time: 1.953 - Number of Queries: 617 - Query Time: 0.97392892268372 (a 15 product subcatagory page with lots of medium sized, unoptimized images.)

I have to select around 120 variables on average, to give users enough options to order. Shouldn't that add up to be more like (all inclusive) around 300 queries? does it have to query 5000 times to get 120 attributes?

I will be doing some maintenance tonight to see if there are parsing errors I'm not accounting for. I've been streamlining the CSS and java as much as possible.

[kobra]

why, on a product page, do my queries to the database seem to inflate exponentially?

I have to select around 120 variables on average

And each is at least one DB query and then the relationships etc

[thedjphat]

And each is at least one DB query and then the relationships etc

doesn't this imply that the table structure itself is incorrect?

[kobra]

doesn't this imply that the table structure itself is incorrect?

NO, no implication there at all as if that were the case you would most likely be seeing errors

[windchaser]

Hi again folks.

I'm now about 3 weeks into setting up a zen cart 1.3.9h installation to sell contact lenses at http://opticalnow.ca

I've managed to get everything set up the way it's needed, but now I have issues with parse time and requests, I'm guessing due to the huge amount of attributes that have to be pulled from the DB before the pages can be displayed.

Contact Lenses are pretty specific, product wise. I've arranged the attributes in two sets to account for selling left and right pairs, using flexible attributes to define the layout.

The Sets of attributes contain values for the following variables:

BC / DIA
Power Range
Adds (if any)
Axis (if any)
Cyl (if any)
Quantity (as a price factor)
Base Price (as a hidden base attribute)

On average, each product has between 80-120 attributes to display on a product page, and most products have a set of attributes that are unique.

I've disabled everything I can find to improve product load speeds, optimized the database, and even removed some javascript. It seems like the cart is trying to do too many queries per product page.

This page for example has a ridiculous load speed.

Parse Time: 17.119 - Number of Queries: 4948 - Query Time: 10.224817272491

HALP!

Just curious: what image files are you using for all your images? BMP, JEPG, etc...

Try GIFs.

If you have already done so, then it's probably something else.

At your side, keep every file (especially image files) you want to display in the smallest size possible.

Cheers!

[thedjphat]

assorted image files. It's the least of my trouble though, it's all about query time, and my not so good sql host (godaddy).

[windchaser]

i scraped my images from all over also. but i did some work to change them into gif files since i heard that gif is 'good for web site display' some time back.

i'm not sure about godaddy's host capabilities and so i won't make any comment but your site really does has a lag feel. seems to need some time to load pages.

try change your images to gif files first so that you can be sure that the lag in the page load is not your fault. its a procedure to zero-in to the problem.

oh yar, i did respond to your messages in the flexible attributes forum. any solution?

[thedjphat]

Please try to keep you comments over here and I will help as much as I can, posting in the flexible attributes section is badly off topic, which is why I made this topic.