Hi Reinaldo,
Involved fields should be indexed for better performance ?
<dynamicField name="*_long" type="long"* indexed="false"*
stored="false" required="false" multiValued="false"
docValues="true" />
Sylvain
Le sam. 18 avr. 2020 à 18:46, Odysci <[email protected]> a écrit :
> Hi,
>
> We are seeing significant performance degradation on single queries that
> use fq with multiple values as in:
>
> fq=field1_name:(V1 V2 V3 ...)
>
> If we use only one value in the fq (say only V1) we get Qtime = T ms
> As we increase the number of values, say to 5 values, Qtime more than
> triples, even if the number of results is small. In my tests I made sure
> cache was not an issue and nothing else was using the cpu.
>
> We commonly need to use fq with multiple values (on the same field name,
> which is normally a long).
> Is this performance hit to be expected?
> Is there a better way to do this?
>
> We use Solr Cloud 8.3, and the field that we use fq on is defined as:
>
> <dynamicField name="*_long" type="long" indexed="false"
> stored="false" required="false" multiValued="false"
> docValues="true" />
>
> Thanks
>
> Reinaldo
>
