Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    42
    Plugin Contributions
    0

    Default 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?

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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!

 

 

Similar Threads

  1. Replies: 5
    Last Post: 10 Aug 2013, 07:14 PM
  2. Load time problem: is it the cart configuration or my host?
    By rwslippey in forum General Questions
    Replies: 20
    Last Post: 23 Jul 2010, 06:29 PM
  3. Wrong time affecting Specials
    By Diego Vieira in forum Basic Configuration
    Replies: 0
    Last Post: 22 Oct 2009, 01:44 AM
  4. Reducing index page load time... Images
    By rainthebat in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 24 Jan 2008, 05:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg