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