In the documentation for the terms aggregation it is stated that to retrieve all terms you'd normally go for a composite aggregation and use paging.
Since for our current use-case having a one-shot query would be much easier, I'm wondering if there is any rule of thumb for how many terms are too many.
We at the moment have around 600 terms, don't anticipate going about 1000 in the near future, and the query is speedy (<150ms).
I realize there are many variables to account for, and if you tell me which numbers you need I would be happy to provide them
Alternatively, can you suggest some metrics to keep an eye on? I mean, what would the main concern be with terms aggregation of large
size? Memory usage?