Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2005
    Posts
    46
    Plugin Contributions
    0

    Default Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    Hello!

    I am running a shop (testing) with Zencart 1.3.7. I should import here 5500 categories and 360.000 products.

    I just imported only the categories but I am already experiencing SERIOUS performance problems. I am using a fresh install with no tweaking. You can try it for yourself:
    http://test.bendoo.nl (select german language, then go to 1 of the 2 main categories and try to browse).

    Are these problems to be expected when using these amount of categories and products?

    What could be done to improve this?

    Any suggestiones or similar experiencies???

    Many thanks in advance for your ideas!
    Bert Hiddink

  2. #2
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    There are several things you can do - #1 being - turn off the category counts in the Admin> Configuration> My store and make sure that gzip is enabled. Also- is this a dedicated server or shared hosting?
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  3. #3
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    Optimizing the images etc would help too - http://www.websiteoptimization.com/s...est.bendoo.nl/
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

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

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    If you are running this slow with just categories and no products I would seriously start looking into a better hosting solution for your site ...
    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: v1.5.5]
    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!

  5. #5
    Join Date
    Aug 2005
    Posts
    46
    Plugin Contributions
    0

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    Hello, Kim (and Ajeh):

    Quote Originally Posted by Ajeh View Post
    If you are running this slow with just categories and no products I would seriously start looking into a better hosting solution for your site ...
    Quote Originally Posted by Kim View Post
    There are several things you can do - #1 being - turn off the category counts in the Admin> Configuration> My store and make sure that gzip is enabled. Also- is this a dedicated server or shared hosting?
    Thanks for your help...I turned off category counts and this helped already a LOT!!! Furthermore, it is indeed running on a shared server and will move to a dedicated server as soon as everything is working fine.

    Thanks again!
    Bert Hiddink

  6. #6
    Join Date
    Aug 2005
    Posts
    46
    Plugin Contributions
    0

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    Quote Originally Posted by hiddink View Post
    Hello, Kim (and Ajeh):

    Thanks for your help...I turned off category counts and this helped already a LOT!!! Furthermore, it is indeed running on a shared server and will move to a dedicated server as soon as everything is working fine.

    Thanks again!
    I addition to what I said above, I noticed that the back-end (admin-section) is still very SLOW although here I set also cat-counts=off.

    Could there be another reason here?

    Thanks again in advance!
    Bert Hiddink

  7. #7
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    1.Try optimising images.. index page.. at least 3 images over 20k in size..
    2.Move to dedicated server asap.. otherwise going to be long process entering all those products on such a slow shared server..

  8. #8
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    I'll just add a very brief mouthwatering comment ...

    Version 1.4.0 (currently in development and not ready for general use) has a large number of changes in it to make database querying much more efficient and therefore much much faster especially on large databases. While it won't be out for several months yet, it's something to look forward to ...

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  9. #9
    Join Date
    Aug 2005
    Posts
    46
    Plugin Contributions
    0

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    Quote Originally Posted by DrByte View Post
    I'll just add a very brief mouthwatering comment ...

    Version 1.4.0 (currently in development and not ready for general use) has a large number of changes in it to make database querying much more efficient and therefore much much faster especially on large databases. While it won't be out for several months yet, it's something to look forward to ...

    Hello, DrByte,

    Thanks for this info. How much improvement in terms of efficiency might there be expected: 5%, 10%, 25% or even more?

    Thanks!!!
    Bert Hiddink

  10. #10
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Performance issues with Zencart 1.3.7: 5500 categories and 360.000 products

    You can calculate metrics however you wish. Here's an example to whet your appetite: Preliminary tests on a home page with demo products takes queries down from 800 to 200.

    This is not the place to open a discussion of v1.4.
    I only mention it to show you that we've already been working on known bottlenecks.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v139h Performance Issues on site with many products
    By totalsam in forum Setting Up Categories, Products, Attributes
    Replies: 19
    Last Post: 8 Mar 2012, 09:27 AM
  2. 45,000 queries to load my categories? Horrid performance
    By MotoDelta in forum General Questions
    Replies: 25
    Last Post: 12 Jun 2008, 05:59 PM
  3. Performance issues with large category
    By cablesimple in forum General Questions
    Replies: 8
    Last Post: 7 Dec 2007, 01:04 AM
  4. Title Issues for just products and categories
    By compnet32 in forum General Questions
    Replies: 0
    Last Post: 19 Sep 2007, 08:04 PM
  5. Cache and Performance issues
    By GreggShort in forum General Questions
    Replies: 5
    Last Post: 29 Jul 2007, 09:41 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR