cancel
Showing results for 
Search instead for 
Did you mean: 

category with more products , takes more time to load

category with more products , takes more time to load

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

 

5 REPLIES 5

Re: category with more products , takes more time to load

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

Re: category with more products , takes more time to load

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

Re: category with more products , takes more time to load

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

Re: category with more products , takes more time to load

Dear @tonysar 

Thanks alot,

i found the reason,

it was Elasticsearch

i downgraded from 7 to 6 then all works well.

Regards

Gabriel

Re: category with more products , takes more time to load

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