Hi,
I have a fulltext index on a bucket with about 250k documents with the json format:
{
“title”: “foo bar”,
“timestamp”: 1234,
“lead”: “foo bar”,
“type”: “story”,
“text”: “foo and bar”
}
A query like
{“size”:100,“sort”: ["_score"],“query”:{“query”:“and”}}
returns in < 20 ms with about 75k results (yes I know “and” a bad example, but a good test to see what happens with a large result set).
If I change to a custom sort field like
{“size”:100,“sort”: [“timestamp”],“query”:{“query”:“and”}}
the query needs > 1s, so 20 times slower.
Is there a way to make this faster? Or at least a reason why a custom sort is so much slower than a sort with _score or _id?