My store has around 30k categories and about 150k products in it. While general performance is good (1-3 seconds per click), certain clicks from the top level generate HUGE queries (38k to be exact) that take way too long to load.
I understand 1.39 or 1.40 will have substantial improvements in the code to load them. So two quick questions:
1. Is there an estimated release timeframe for the improved version?
2. Is there anything I can do in the interim to remediate these queries? I'm still a tad confused why the categories click ends up doing so much work...
Mods i have are:
1. Multisite (with cat filter disabled)
2. Better categories (not necessary)
3. Dual pricing
Thanks a million (or 38,000)...
CHris
Bookmarks