But i'm not sure to understand them.
Should using options, "execution" : "bool", "_cache": true, improve
performance ?
If you filter by only one group ID, I think the term filter would be preferable:
Which would be cached by default and the problem is solved
If you need to filter by more than one group ID, I would choose
depending on what kind of queries are run most often. If users
normally choose the same sets of group IDs, I would leave caching
settings to default. Otherwise, I would only change the execution to
"bool", and I wouldn't turn on _cache because that would also cache
the bool filter - and I assume that would change too often - while
individual term filters will be cached by default.
Any other tips or recommendations about filter cache tunning ?
I think if you want to fine-tune your cache settings, there's no
getting away from some testing and monitoring. Here's an interesting
blog article that might help:
Which would be cached by default and the problem is solved
If you need to filter by more than one group ID, I would choose
depending on what kind of queries are run most often. If users
normally choose the same sets of group IDs, I would leave caching
settings to default. Otherwise, I would only change the execution to
"bool", and I wouldn't turn on _cache because that would also cache
the bool filter - and I assume that would change too often - while
individual term filters will be cached by default.
Any other tips or recommendations about filter cache tunning ?
I think if you want to fine-tune your cache settings, there's no
getting away from some testing and monitoring. Here's an interesting
blog article that might help: ElasticSearch Cache Usage - Sematext
Oh yes, excellent article, i knew it but don't bookmark it, that done now !
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.