Admin page showing 502 error on running search

Hi,
My project has above 230K orders enlisted. We are using woocommerce as our e-commerce solution. Unfortunately whenever we go in Admin->orders section and conduct a search operation say like search a customer for his or her orders. The process gets crashed and browser returns a 502 error. I have tried increasing the max_execution_time but it didn’t help much.

Can anyone please guide how to permanently fix the 502 error in admin listing pages with increasing number of rows?

Thank you