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
Sent: September 21, 2016 7:40 PM
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
> 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
> Please help. Any advise would be appreciated.
> View this message in context: http://lucene.472066.n3.
> Sent from the Solr - User mailing list archive at Nabble.com.