Post by bluby » Wed May 16, 2012 2:50 am

OpenCart - v1.5.2.1

Our site: http://69.85.93.10/~flagsand

We are a bit concerned because we have only added about 1100 products and we noticed the storefront is extremely slow now. Clicking and browsing is unacceptably slow so I am wondering if there is some sort of issue we are facing?

We plan on adding over 50,000 products.

Is this normal? Your help is appreciated!

Bluby

Newbie

Posts

Joined
Wed May 16, 2012 2:47 am

Post by Qphoria » Wed May 16, 2012 8:53 am

Products aren't the issue... There are stores with 75000 products... It is categories.. if you have a billion categories and they are all subcategorized, it takes longer to recursively build each category. The db cache resolves this issue, but the real culprit is the category product counts next to each category in the top menu as this isn't cached because of the way it works.

In 1.5.2 you can disable category counts from the side modules using the admin configuration for the module.
But the header one is hardcoded for now so you'll need to make a tiny edit to the code for that and it is completely free.
http://forum.opencart.com/viewtopic.php?t=33929#p166221

Once you do that it will be instantly faster.

I will add a setting for that to the core for 1.5.3 because it is a common problem for stores with ridiculous amounts of categories.

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bluby » Wed May 16, 2012 11:28 pm

Excellent response, thanks for the solution! Very pleased.

Newbie

Posts

Joined
Wed May 16, 2012 2:47 am

Post by bluby » Wed May 16, 2012 11:39 pm

I've followed this but it's still slow.

Check for yourself...http://69.85.93.10/~flagsand

Newbie

Posts

Joined
Wed May 16, 2012 2:47 am

Post by Avvici » Thu May 17, 2012 12:35 am

It actually is a little faster because I remember checking it yesterday. However....it's still slow. Trial/Error.
Look into some page caching here: http://www.opencart.com/index.php?route ... ort=rating

And might as well minify things with this script: http://www.opencart.com/index.php?route ... name=Tcalp

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC
Who is online

Users browsing this forum: No registered users and 93 guests