Re: Huge Query execution time for multiple ORs

2017-12-04 Thread Faraz Fallahi
Will do thx Am 04.12.2017 9:27 nachm. schrieb "Emir Arnautović" < emir.arnauto...@sematext.com>: > Hi Faraz, > When you say query without sort, I assume that you mean you omit sort so > you expect it to be sorted by score. It is expected to be slower than equal > query without calculating score -

Re: Huge Query execution time for multiple ORs

2017-12-04 Thread Emir Arnautović
Hi Faraz, When you say query without sort, I assume that you mean you omit sort so you expect it to be sorted by score. It is expected to be slower than equal query without calculating score - e.g. run same query as fq. What you observe can be explained with: * Solr is calculating score even not

Re: Huge Query execution time for multiple ORs

2017-12-04 Thread Faraz Fallahi
Hi guys, Sorry to bother you again, but i am really confused: Ive used solr admin website and created a query with lots of ORs using solr 4.7. When i execute the query without a sort it executes in round about 3.5 - 4 seconds. When i execute it with a sort on a field called pubdate it takes abou

Re: Huge Query execution time for multiple ORs

2017-11-30 Thread Faraz Fallahi
Uff... I See.. thx dir the explanation :) Am 30.11.2017 3:13 nachm. schrieb "Emir Arnautović" < emir.arnauto...@sematext.com>: > Hi Faraz, > It is a bit worse than that - it also needs to calculate score, so for > each matching doc of one query part it has to check if it appears in > results of o

Re: Huge Query execution time for multiple ORs

2017-11-30 Thread Emir Arnautović
Hi Faraz, It is a bit worse than that - it also needs to calculate score, so for each matching doc of one query part it has to check if it appears in results of other query parts. If you use term query parser, you avoid calculating score - all doc will have score 1. Solr is based on lucene, whic

Re: Huge Query execution time for multiple ORs

2017-11-29 Thread Faraz Fallahi
Hi Toke, Just to be clear and to understand. Does this mean that a query of the form author:name1 OR author:name2 OR author:name3 Is being processed like e.g. 1 query against the index with author:name1 getting 4 result Then 1 query against the index with author:name2 getting 3 result Then 1 que

Re: Huge Query execution time for multiple ORs

2017-11-28 Thread Faraz Fallahi
Hi Thx for all the replies. I think in any way tagging them is probably the best solution on any way. Best regards Am 28.11.2017 15:39 schrieb "Toke Eskildsen" : > On Tue, 2017-11-28 at 11:07 +0100, Faraz Fallahi wrote: > > I have a question regarding solr queries. > > My query basically contai

Re: Huge Query execution time for multiple ORs

2017-11-28 Thread Toke Eskildsen
On Tue, 2017-11-28 at 11:07 +0100, Faraz Fallahi wrote: > I have a question regarding solr queries. > My query basically contains thousand of OR conditions for authors > (author:name1 OR author:name2 OR author:name3 OR author:name4 ...) > The execution time on my index is huge (around 15 sec). When

Re: Huge Query execution time for multiple ORs

2017-11-28 Thread Mikhail Khludnev
Long queries hurt Solr on many layers. You can experiment with https://lucene.apache.org/solr/guide/7_1/other-parsers.html#terms-query-parser On Tue, Nov 28, 2017 at 1:07 PM, Faraz Fallahi wrote: > Hi > > I have a question regarding solr queries. > My query basically contains thousand of OR con

Huge Query execution time for multiple ORs

2017-11-28 Thread Faraz Fallahi
Hi I have a question regarding solr queries. My query basically contains thousand of OR conditions for authors (author:name1 OR author:name2 OR author:name3 OR author:name4 ...) The execution time on my index is huge (around 15 sec). When i tag all the associated documents with a custom field and