for the past few days I’ve been trying to find a way to speed up cs-cart.
I have a store with alot of updates so the cache is cleared really often. They way current cs-cart cache works in my scenario make my store to work most of the time without cache.
The only way to speed things up is to make the store work fast without cache.
I’ve found out via the debbuger that if there are alot of categories the function fn_top_menu_form creates hundreds of queries in order to generate menu tree.
In my opinion it would be alot better to generate the tree via single query or maybe with multiquery, rather than querying database with hundreds small queries. Has anyone ever investigated it? Am I missing something?
I would really appreciate some feedback from developers. Maybe it’s possible to optimize this part of cs-cart code