URGENT-Category load time 50sec

[gabriel_helle]

Hello

any categories with high products numbers(+10K) get very high time to load (40-50 sec).

.->https://ibb.co/VC2XyZs

can be checked.

as much as the category has more product , take more time.

5K product take 8sec...50K products take 45sec !

-i disable all 3rd parties module

-i copy the website for double check to AWS -> http://35.157.228.195/  

-servers has enough CPU/RAM

-i checked with LUMA theme 

-server side has been checked several time

*also in pagination(navigate page to page) is same point, if the category is heavy of product ,its take lot of time to load.

"we talk about un-cached page", for uncached no problem.

anyone could help

im in very bad situations. 

Regards

Gabriel

[Shailesh G]

Hi,

I have also been in similar situation but products were ~3800

I had to disable Elastic cloud and also disable catalog search configuration under which they give message that, this will slow down your site. And, I also disabled Flat Catalog & Products settings.

https://docs.magento.com/user-guide/catalog/search-configuration.html

Above might not be directly applicable for your case, but sharing how I got my site to work faster. Before that, Even saving products from Backend was taking 5 to 8 minutes!

[gabriel_helle]

Dear @Shailesh G 

finally i found the reason,

it was Elasticsearch

i downgraded from 7 to 6 then all works well.

Regards

Gabriel

[Shailesh G]

That's great. Thanks for updating.

Looks for elasticsearch is a common culprit for your site & mine, in downgrading performance.