category with more products , takes more time to load

[gabriel_helle]

Hello,

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

Regards

Gabriel

[tonysar]

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.. 

[gabriel_helle]

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 ?

REgards

Gabriel

[tonysar]

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 .. 

[gabriel_helle]

Dear @tonysar 

Thanks alot,

i found the reason,

it was Elasticsearch

i downgraded from 7 to 6 then all works well.

Regards

Gabriel

[tonysar]

Thanks for the solution . it will help me and others if they have same issue .