I did 3 sets of query as followed:
- multi-value field only : slow
-  single field value: fast
- multi-value and single field combine: slow

So yes, the difference is base on which field you search against. I'm 
experiencing the same issue described here: 


This individual ended up using elasticsearch which doesn't help me. I'm 
wondering if multivalue fields cannot exceed certain terms? I only have 54 to 
60 terms.

  Original Message  
From: arafa...@gmail.com
Sent: September 21, 2016 7:40 PM
To: solr-user@lucene.apache.org
Reply-to: solr-user@lucene.apache.org
Subject: Re: Performance Issue when querying Multivalued fields [SOLR 6.1.0]

Do you _return_ the same set of fields in both queries? Is the difference
truly just which field you search against?


On 22 Sep 2016 3:03 AM, "slee" <sleed...@gmail.com> wrote:

> I've been doing a lot of reading on this forum with regards to performance
> on
> multivalued fields, and nothing helps. When I query on singlie fields, the
> response time is fairly quick (typically < 1sec). However, when I query on
> multivalued fields, the response is > 2 mins ~ 3 mins.
> Here's my current environment:
> CPU: Intel Xeon E5-2637 v3 @ 3.5Ghz
> RAM: 16GB
> OS: Windows 7 64 Bit
> HD Controller: SCSI
> SOLR Documents: 17 million.
> Average # of terms in a multivalued fields: 54~60
> Schema: Multivalue field has indexed="true"
> I've set both my XMS and XMX to 5g, using -m 5g option. Another thing I
> realized is, every time I query on the multivalued, the memory consumptions
> takes up over 90%. Could this also be the cause of the issue? I have tried
> MMapDirectoryFactory, the results seems to be the same (vs the default
> NRTCachingDirectoryFactory).
> Please help. Any advise would be appreciated.
> Thanks.
> --
> View this message in context: http://lucene.472066.n3.
> nabble.com/Performance-Issue-when-querying-Multivalued-
> fields-SOLR-6-1-0-tp4297255.html
> Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to