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