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: http://stackoverflow.com/questions/29745135/performance-issue-with-multivalued-field-in-lucene 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? Regards, Alex 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. >
