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 <ody...@gmail.com> 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 >