OpenCart Community

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

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.

Excellent response, thanks for the solution! Very pleased.

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

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

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