What should be chosen for a Magento 2.4.7 store with 25,000 visual SKUs?
Should we go for Opensearch 2.13 or Elasticsearch 8.5? Which one will give us the best performance?
As far as we can see,
There are the following issues with Elasticsearch 8 since they have disabled sorting and aggregation in the _id field by default for performance reasons,
this functionality was deprecated in ES 7.6.
You can re-enable it by updating the dynamic cluster setting: indices.id_field_data.enabled