The grids in M2 are slow when you get > 1 million orders. I’ve speeded up individual columns with plugins, adding fulltext indexes, etc. but this is a bit whack a mole. I’m curious if someone’s tried to use ElasticSearch for Customer/Sales Orders grids.
I have a basic understanding how ElasticSearch works and how it works with Magento in 2.4+ – I know we feed it a product index namespaced to something like magento2_product_{storeid}. I fought a battle to try to get it to index stock status.
And I know it’s fast. I know we could probably feed it other things to search. I don’t know if we could secure those things to use Magento ACL. Worthwhile?
submitted by /u/deyterkourjerbs
[link] [comments]