Magento 2 Search Is loading very slow and mysql server goes away

[radiantweb]

Hello there,

I have 1.5 million products.

Migrated from magento 1.9 to Magento 2.3.4

My Search is always loading the page while searching and it gives error with Gateway Timeout.

So search is loading very slow and it never returns results.

How can i solve this issue ?

[Bhanu Periwal]

Hi @radiantweb 

Kindly refer below link :

https://magenticians.com/magento-optimization/

It may help you to improve search speed.

If issue resolve, please click on 'Kudos' & Accept as Solution!

[Sunil Patel]

Hello @radiantweb 

1) first disable Flat Catalog

2) move to search engine based on elasticsearch

Then do reindex and try it