A single query with tens of thousands of terms is very clearly a misuse of Solr. If it happens to work at all, consider yourself lucky. Are you using a standard Solr query parser or the terms query parser that lets you write a raw list of terms to OR.
Are your nodes CPU-bound or I/O-bound during those 50-second intervals? My bet is that your index does not fit fully in memory, causing lots of I/O to repeatedly page in portions of the index and probably additional CPU usage as well. How many rows are you returning on each query? Are you using all these terms just to filter a smaller query or to return a large bulk of documents? -- Jack Krupansky On Thu, Dec 17, 2015 at 7:01 AM, Modassar Ather <modather1...@gmail.com> wrote: > Hi, > > I have a field f which is defined as follows. > <fieldType name="string" class="solr.StrField" sortMissingLast="true" > omitNorms="true"/> > > Solr-5.2.1 is used. The index is spread across 12 shards (no replica) and > the index size on each node is around 100 GB. > > When I search for 50 thousand values (ORed) in the field f it takes almost > around 45 to 55 seconds. > Per my understanding it is too slow. Kindly share your thoughts on this > behavior and provide your suggestions. > > Thanks, > Modassar >
