Backend Product Grid Issue

[gkarthick87]

we have more 100,000 products on site category more than 1800 and 1800 Attribute sets whenever we are trying to open product from backend catalog-->product it is taking more than 5 minute to open product grid.

Any help would be appreciated.

[shubham_khandelwal1]

Hi @gkarthick87 

Can you check varnish cache is enable or not in your magento environment? If not then please enable it and then try.

You can find Cache configuration using below Devdocs:

config-varnish-magento 

Hope this helps you.

Problem Solved? Click kudos & accept as solution.  

[gkarthick87]

@shubham_khandelwal1 We already have Varnish Cache but this product grid only taking more time. 

[shubham_khandelwal1]

Hi @gkarthick87 

Okay now can you please check your logs and reports is there any kind of error related to sql or something else? because there could be a reason like magento is taking time to get value of any attribute of something else.

Hope this helps.

Problem solved? Click kudos & accept as solution