If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

zen cart for contact lenses?

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.

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.

Re: zen cart for contact lenses?

hmmm.... well, no errors that I can see, however I still have to check for warnings and possibly missing files... I have had some trouble with the lightbox 3 plug-in, and removed it. For some reason it conflicted with my new jquery lavalamp menu.

I'm still not sure how fetching 120 attributes can cause 5000 queries, it doesn't add up to me. I have seen references to caching modules and performance mods which reduce the number of queries overall, and really the question to ask, is if all this querying can be done more efficiently, in this open source community, why hasn't it been done yet?

From what I've heard about zen cart 1.4 (or is it 2.0) a lot of these exponentially multiplied queries have been removed in favor of parsing fewer queries.

Unfortunately I have not been able to find a patch or mod to improve this yet, if anyone has any ideas for performance mods for 1.3.9h please let me know.

Re: zen cart for contact lenses?

So to check this out properly, I've installed in the header.tpl:

error_reporting(E_ALL);
ini_set('display_errors', '1');

I have a LOT of warnings, which I have to assume slow things down.

Notice: Use of undefined constant ATTRIBUTES_PRICE_FACTOR_FROM_SPECIAL - assumed 'ATTRIBUTES_PRICE_FACTOR_FROM_SPECIAL' in /home/content/29/7029429/html/includes/functions/functions_prices.php on line 1031

Notice: Undefined index: id in /home/content/29/7029429/html/includes/modules/iC_AthemeV1.3/attributes.php on line 581