-
Notifications
You must be signed in to change notification settings - Fork 9.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Catalog fulltext search performance #36408
Comments
Hi @p24-max. Thank you for your report.
Make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:
For more details, review the Magento Contributor Assistant documentation. Add a comment to assign the issue: To learn more about issue processing workflow, refer to the Code Contributions.
🕙 You can find the schedule on the Magento Community Calendar page. 📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket. ✏️ Feel free to post questions/proposals/feedback related to the Community Contributions Triage process to the corresponding Slack Channel |
Hi @engcom-November. Thank you for working on this issue.
|
Hi @p24-max , |
@engcom-November any news? |
Preconditions and environment
Steps to reproduce
At my machine this query takes 663ms to execute
Expected result
Backend product catalog fulltext search is faster when working with more products
Actual result
Fulltext search in catalog > products executes for ~3 seconds which is annoying when working with it whole day
Additional information
MATCH ... AGAINST ...
https://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html with a FULLTEXT index:Example of improved query (lacks match of joined t2.value, this should be extracted into single query or UNION without join for performance reasons. Multiple MATCH AGAINST in single query slows down a lot):
Execution time: 90ms (vs. 663ms current implementation)
Release note
Improved catalog products fulltext search performance
Triage and priority
The text was updated successfully, but these errors were encountered: