Replace Customer / Order search with ElasticSearch

[JamesFX2]

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]

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.