I use AWS Elasticsearch. I have stored ~40 Mil documents and I want to fetch large amount of query results (e.g. one milion most relevant document). I am fetching document titles only but searching is executed through docs contents.
I have problem that fetching is quite slow and its speed is decreasing. I use parallel fetching using sliced scroll api.
How to make elastic to fetch results faster?