Forums / Setting Up Categories, Products, Attributes / products + attributes in cart affecting page load time

products + attributes in cart affecting page load time

Locked

Started by mylibros_com on 7 Oct 2008, 2:02 AM · Views: 1,033

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
7 Oct 2008, 2:02 AM
#1
mylibros_com avatar

mylibros_com

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

products + attributes in cart affecting page load time

I know the database issues are going to be addressed in ZC v1.4 but I wanted to mention my problems here. When I add a product to the shopping cart with a lot of attributes it introduces a TON of queries to each page and if you add enough products with attributes it eventually times out and won't allow you to even make it through the checkout process.

I've taken the recommendations in the FAQ for limiting the number of queries and have also turned off almost every sidebox and featured product box possible to see if it helps but it is very obvious that it slows down considerably when you add products with lots of attributes.

The site is www.gobibledownloads.com.

I am on a shared DreamHost server and I understand it may not offer the proper MySQL configuration or guaranteed resource allocation levels but I want to at least try to work with it because this site is storing large files for download and needs plenty of storage space and I can't find a certified ZC host that offers that same level of storage or greater.

Any thoughts on the attribute query issue before I try moving the site to a ZenCart certified host or should I wait it out for the 1.4 update and see if that helps? Dev team, any idea when that release is coming? :hug:

11 Oct 2008, 1:31 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products + attributes in cart affecting page load time

If you comment out the info about the shopping cart totals in the header and in the top of the shopping cart, how much does this save you?

NOTE: when testing, be sure you are commenting out where the information is gathered/prepared and not just where the results are displayed ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!