My store runs super fast with around ~6000 products enabled, but when I enable 500 more (lets say around 6500 enabled) then it starts hanging.When I disable the 500 product category then it goes super fast again. I have checked with different categories and it does the same (so i not category something issue). Look like have a limit of 6000 products something and then have issues.
I am giving you some server specs and tips I 've see that may help you find solution faster.
My server is dedicated:
8 Physical CoresAMD EPYC 7282 2.8 GHz
64 GB RAM
php7.4 with 32gb memory limit and high optimizations
MySQL with innodb most tables and 40GB Buffer pool size
I checking the cs-cart debugger and the pages queries and caching are far away from memory limits, so assume this should not be the issue.
Does cs-cart have any config about big catalogues that I have to revise something?
Can someone point me what could be the issue please?