AbanteCart Community
Shopping Cart Operations => Support => Topic started by: smallfish on April 15, 2018, 03:15:04 AM
-
what is the purpose of this line in \storefront\controller\blocks\category.php???
$output = array_merge($output,$this->_buildCategoryTree($all_categories,$category['category_id'], $category['path']));
I have 8000 categories (2 languages which is double, then 16000 records), this line wastes 30 seconds to build the categories tree.
Can I cancel this line? If I cancel it, will abantecart builds the categories tree correctly? Any affect on abantecart system?
If it is not allowed to cancel it, how can I improve the performance for rebuilding the categories tree?
Thank you.
-
This is a display block for categories. Manipulation of this code will only affect the display.
Check if you have product count in categories enabled. This will slow query down.
-
This is a display block for categories. Manipulation of this code will only affect the display.
Check if you have product count in categories enabled. This will slow query down.
In fact, I didn't find where to disable the product count in backend admin. However, I have modified the sql statement in the script to ignore the product count and categories_to_store.
So that I can make sure that the mentioned program line wastes a lot of time to build the categories tree. It calls itself many times to build the whole categories tree.
Finally, I have forgotten to mention that there is no products in the database. I just have created 8000 categories only. (4 main categories, each has 20-100 2nd level sub categories and each 2nd sub category has 2 to 10 3rd level sub-categories., each 3rd sub-category has 2 to 10 4th level sub-categories.)
Can you rewrite or redesign the categories table to make it build the categories tree fast?
Thank you!
-
imho we cannot to make sql better. Every category have parent_id and tree will builds recursively anyway. But probably in case when you have a lot of categories you should improve template of categories in way when you ask only one branch of parent category. I mean ajax call for expand button click.
In this case main tree will contain only root categories. And then after click you asks children.
Otherwise you will have server performance problems.
-
Category model and SQL can be improved for larger categories count. We will add this to TODO list for version 2.0
-
Category model and SQL can be improved for larger categories count. We will add this to TODO list for version 2.0
Good to know that you will improve it. It seems that recursive function is not good for building large categories tree. The category table may be needed to re-design for for better performance.