Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
hi thank you for your reply, yes i figure that, but it is puttin huge load on server, and my site is way too slow over 100 sec for home page, and i dont have any product at all on home page., shoudnt enabling flat_category index resolve this? as it shouldnt be then requesting this much data in each url request? as for server i have huge server with 2 gold xeon CPU's with 16core each so server is not the problem, i have tried changing server as well and no use.
