Hi,

My installation of 1.5.1.1 was working fine on my new development environment until I restructured my categories to add more tiers. Now I have massive performance degradation.

Summary Info:-

- New, clean install
- Shoppica Theme applied (http://www.shoppica.net)

All was working fine until I recently made some seemingly trivial changes.
Here is the deal:-

I have successfully imported a list of approximately 1500 products.
For testing purposes, I originally had all products in a simple 1 tier category layer.

The products are related to English Premiership Football teams so I will use actual examples.

Example of original TEST Category tree
> Browse by Team (top) > Manchester United > LIST OF PRODUCTS

Apart from too many products being in a single category, this worked absolutely fine and page load times were as expected.

Example of New (more organised) category tree
> Browse by Team (top) > English Premiership > Manchester Untied > > Executive Gifts > Ties > LIST PRODUCTS

I have only changed the category structure and yet page load times have massively degraded.

Total number of products 1426
Total number of categories 726 (most products are now located 4 tiers down)

I don’t consider this to be a massive load, nor abnormal configuration.

I originally assumed that this issue related to MySQL queries / MySQL indexing surrounding categories on Open Cart and how they are handled from parent to child but maybe only when 3,4 or more layers exist but after testing with the default theme it appears that Shoppica might be slowing things down.

Open Cart is definitely slower with these categories but when I re-apply Shoppica theme page load times almost double.

Could the top menu category tree be causing a problem?

I intend to add some debugging to test further and disclose page load times and any problem MySQL queries but this may take some time. I will update thread once implemented if I find anything of interest.

Has anyone else noticed performance degradation on 1.5.1.1 with Shoppica when adding this many categories which are 3 or more tiers deep?

Thanks in advance!

Gary