cancel
Showing results for 
Search instead for 
Did you mean: 

Backend Product Grid

Backend Product Grid

Hi,

 

I'm trying to find product using search keyword(M2.3.5-p1 backend product grid) but it's taking more time to bring results like 2-3 mins. which is fine on M1.9

 

 

5 REPLIES 5

Re: Backend Product Grid

Hi @gkarthick87 


Enable flat table from admin configuratin and run indexer command:

php bin/magento indexer:reindex


It will improve your product search.
Problem solved? Please click on 'Kudos' & Accept as Solution!

Re: Backend Product Grid

@gkarthick87 

 

Can you check process-list in MySQL or any sleep queries in database? Find out if there any query converting to sleep or taking time to fetch data.

Manish Mittal
https://www.manishmittal.com/

Re: Backend Product Grid

How can I check this? I'm very new to M2.3.5

Re: Backend Product Grid

do you have new relic? you can check using this. Or you can run show processlist command in mysql when loading grid in admin. You will find all queries which taking time or if there any sleep queries also will be there.

Manish Mittal
https://www.manishmittal.com/

Re: Backend Product Grid

A backend product grid is a UI component that allows users to filter and sort products by different attributes. This can be useful in situations where you have a large number of products and want your users to quickly find what they’re looking for. It is easy to find essay samples online and also hire a professional on time to complete your work timely.