In a word, “yes”. I also suspect your corpus isn’t very big. I think the key is the facet queries. Now, I’m talking from theory rather than diving into the code, but querying on a docValues=true, indexed=false field is really doing a search. And searching on a field like that is effectively analogous to a table scan. Even if somehow an internal structure would be constructed to deal with it, it would probably be on the heap, where you don’t want it.
So the test would be to take the queries out and measure performance, but I think that’s the root issue here. Best, Erick > On Apr 14, 2020, at 11:51 PM, Revas <revas2...@gmail.com> wrote: > > We have faceting fields that have been defined as indexed=false, > stored=false and docValues=true > > However we use a lot of subfacets using json facets and facet ranges > using facet.queries. We see that after every soft-commit our performance > worsens and performs ideal between commits > > how is that docValue fields are affected by soft-commit and do we need to > enable indexing if we use subfacets and facet query to improve performance? > > Tha
