Problem Statement 1:
...
Use Elastic search scroll api . 'Scroll API ' can be used to retrieve large numbers of results (or even all results) from a single search request, it will work in same way as cursor on a traditional database.
Pros | Cons |
|---|---|
We can retrieve large data set | We can not use scroll api for real time user request |
We can slice the data based upon shards | Performance issues while using it for real time request |
...
Filtering based on userName
Filtering based up on enrolled date (eg:- between start and end date)
Filtering based upon root org name
Filtering based upon progress status ( eg:- user progress between 20-40% )
...