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!