I'm wondering if you have any tips to increase the query performance of App Search. We've an index with ~10 million documents which have quite poor query performance. Simple queries can take between 4-5 seconds and paging between the documents in the App Search dashboard (/documents) takes >2 seconds.
This can be compared to ~300 ms (for paging in the dashboard) for another index which only have ~300k documents, but identical schema/data.
The query performance barley changed when moving from a 8 GB RAM to a 58 GB RAM cluster in Elastic Cloud.
I'm quite green on elasticsearch in general, but noticed that the index .app-search-engine-xxxxxx (the one powering the queries I assume) only is divided between two shards? Could this be related to the poor performance? Is there any possibility to increase the shard count?