On 3/17/2017 12:46 AM, Ganesh M wrote: > For how many ORs solr can give the results in less than one second.Can > I pass 100's of OR condtion in the solr query? will that affects the > performance ?
This is a question that's impossible to answer. The number will vary depending on the nature of the queries, the size and nature of the data in the index, and the hardware resources available in the server running Solr. https://lucidworks.com/sizing-hardware-in-the-abstract-why-we-dont-have-a-definitive-answer/ Another wrinkle affecting your question: Lucene has a global configuration called "maxBooleanClauses" which defaults to 1024. This means that if one query with a bunch of AND/OR/NOT clauses ends up with more than 1024 of them, and this configuration value has not been increased, the query will simply fail to execute. This parameter can be increased up to a value a little larger than two billion, but due to the global nature of the configuration, you must increase it in *EVERY* Solr configuration, or you may find that the ones you didn't increase it in will reset it back down to 1024 -- and this will affect every index, because it's global. Thanks, Shawn
