Just to make sure we're not missing the obvious: There's no way to do that calculation as an aggregation (maybe with scripting if there is no other way)?
Retrieving 3 million documents to do a calculation on them will probably never be very fast and it feels like shovelling a lot of documents around, which might not even be necessary.
1 Like
No unfortunately not, the calculation is a little more involved than aggregations, that's good thinking though.
Is there any computation you can do at index time so you can use then standard APIs, pipeline aggregation or scripts?
1 Like
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.