search

magento / community-features

Magento Features Development is an Initiative to Allows Community Memebers Join to Development of Magento Features
46 stars 18 forks source link

Replace Customer / Order search with ElasticSearch #344

Open JamesFX2 opened 1 year ago

JamesFX2 commented 1 year ago

Running a store with a lot of orders and a lot of customers - things like searching in the Customer view by email or Sales Order List by increment_id can take 8s, complex queries can take 2-3x as long. I've been impressed by how fast ElasticSearch seems to be for products, are there any plans to use ElasticSearch in the admin backend for managing customer searches or sales order searches?

We've managed to band-aid searches by adding fulltext indexes to the sales_order_grid and using plugins to do match('increment_id') against - or changing fields from like % searches to eq searches. But there's got to be a better approach than archiving orders or making lots of fulltext indexes.

m2-assistant[bot] commented 1 year ago

Hi @JamesFX2. Thank you for your report. To speed up processing of this issue, make sure that you provided sufficient information. Add a comment to assign the issue: @magento I am working on this

Join Magento Community Engineering Slack and ask your questions in #github channel.