Forums / General Questions / Does having 'Show Category Counts' on or off really make a difference in speed?

Does having 'Show Category Counts' on or off really make a difference in speed?

Locked

Started by tj1 on 3 Jul 2007, 3:35 AM · Views: 969

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
3 Jul 2007, 3:35 AM
#1
tj1 avatar

tj1

Totally Zenned

Join Date:
Mar 2005
Location:
California
Posts:
628
Plugin Contributions:
0

Does having 'Show Category Counts' on or off really make a difference in speed?

I remember back in ZC 1.2.x it made a great difference in speed having 'Show Category Counts' off and opposed to having them on.

And so, I've had this turned off ever since until today that I did a major update to all my products.

It seemed to me it didn't really make any noticeable difference in speed whether I had Category Counts on or off.

I'm using ZC 1.3.7 and I have just over 16,000 products and most of the time my site loads in about one second.

Can some tell me whether the speed/optimization issue was fixed in some of the later versions and whether it really makes difference having this setting on or off?

Thanks.

3 Jul 2007, 3:59 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Does having 'Show Category Counts' on or off really make a difference in speed?

The appropriate setting for your site will depend on your own experience. The performance will be a combination of server speed, server utilization, number of categories and subcategories and products, sales/specials, etc.

In the v1.3 series, a number of database improvements were made, which you appear to be benefitting from.
In v1.4, there are even more improvements.

In short ... if you want them on, turn them on. If it's too slow, you may have to reconsider turning them off. Best to test at several times of the day to determine impact of server busy-ness (ie: for other sites sharing the same server and database host).

For some folks, it makes a huge difference. For others, it's moot.

.
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.