Hi @abhinav , do you have a hint for the following?
I have a FTS index on 40 million documents
If I search for something where the potential results set is small (100 results from 1000 total potential results) the query time is super fast (less than 5 ms).
But if the number of potential matches is higher let’s say 2 millions, no matter how small is the LIMIT the results are returned in 4-6 seconds.
The query contains some sorts, but all are on indexed fields excluding the _score which is calculated at the query time.
Is there a trick that I could use to get the results faster when my LIMIT is around 10 results from x millions?