Hi,
the category setup on my site is four-levels deep, as follows: 1 root category, having 2 subcategories, each of them having 4 subcategories, each of them having aprox 100 subcategories. A total of 540 categories and about 1300 items.
Now, I want a page that show the root category plus its two subcategories. I setup my parameters to display just that - no items, no item count, nothing more.
I face speed problems so I enable the log and I see a total of 2970 queries running to fullfill that request!!! It seems to run one select query for each category, one count(*) for each category and one count(*) on comments for each category.
I must be doing something wrong here.
the category setup on my site is four-levels deep, as follows: 1 root category, having 2 subcategories, each of them having 4 subcategories, each of them having aprox 100 subcategories. A total of 540 categories and about 1300 items.
Now, I want a page that show the root category plus its two subcategories. I setup my parameters to display just that - no items, no item count, nothing more.
I face speed problems so I enable the log and I see a total of 2970 queries running to fullfill that request!!! It seems to run one select query for each category, one count(*) for each category and one count(*) on comments for each category.
I must be doing something wrong here.