we have one problem in our website,
any categories with high products number get more time to load from page to page, even loading the first page.
as much as the products on that category will be more, the load timing become more.
if its cached will be ok, but if not cached some times it take 50sec (if 30K+ product on that category).
About the server, we host in AWS and there is enough CPU and RAM,
and also i change the theme to LUMA, same problem.
the FLAT category are also enable.
any one has an idea
That might be issue with Database , since it needs to process large number of request , you might have to allocate more resources to your DB .. as you mentioned when category is cached , everything is ok .. then look into optimizing your DB..
hello @tonysar ,
i think also its should be from database,
but would you explain more "allocate more resources to your DB"
which parameters or action i have to do ?
sorry for late reply. missed the notification .
your database configuration for mysql , meriadb or percona are set in my.cnf .. you can find my.cnf optimization tools or just optimized version of it on git . however, the best solution would be to look for advice from forum dedicated to your database ..
i found the reason,
it was Elasticsearch
i downgraded from 7 to 6 then all works well.